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 1300: pa_cc_utils.set_curr_function('PROC_INSERT_TRANS');

1296: p_user_id NUMBER,
1297: p_xface_id NUMBER ) IS
1298: count_new_rec NUMBER ;
1299: BEGIN
1300: pa_cc_utils.set_curr_function('PROC_INSERT_TRANS');
1301:
1302: UPDATE GMS_DISTRIBUTION_DETAILS
1303: SET remarks = to_char(PA_TXN_INTERFACE_S.nextval)
1304: WHERE document_header_id = p_xface_id

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

1304: WHERE document_header_id = p_xface_id
1305: AND document_type = 'EXP'
1306: AND distribution_number > 1 ;
1307:
1308: pa_cc_utils.log_message(' Generated new txn_interface_id :'||to_char(SQL%ROWCOUNT));
1309: -- 3466152
1310: -- import process award distributions doesn't work when batch name is not supplied.
1311: -- addaed transaction source in the where clause to have better performance.
1312: --

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

1371: AND GTN.distribution_number > 1
1372: AND GTN.document_distribution_id = TXN.TXN_INTERFACE_ID ;
1373:
1374: count_new_rec := SQL%ROWCOUNT ;
1375: pa_cc_utils.log_message(' GMS Transactions inserted :'||to_char(SQL%ROWCOUNT));
1376:
1377: -- 3466152
1378: -- import process award distributions doesn't work when batch name is not supplied.
1379: -- addaed transaction source in the where clause to have better performance.

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

1595: AND GTN.distribution_number > 1
1596: AND GTN.document_distribution_id = TXN.TXN_INTERFACE_ID ;
1597:
1598: count_new_rec := SQL%ROWCOUNT ;
1599: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1600: DELETE from GMS_DISTRIBUTION_DETAILS
1601: where document_header_id = p_xface_id ;
1602:
1603: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));

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

1599: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1600: DELETE from GMS_DISTRIBUTION_DETAILS
1601: where document_header_id = p_xface_id ;
1602:
1603: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1604: DELETE from GMS_DISTRIBUTIONS
1605: where document_header_id = p_xface_id ;
1606: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1607: pa_cc_utils.reset_curr_function;

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

1602:
1603: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1604: DELETE from GMS_DISTRIBUTIONS
1605: where document_header_id = p_xface_id ;
1606: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1607: pa_cc_utils.reset_curr_function;
1608: EXCEPTION
1609: When others then
1610: pa_cc_utils.log_message(' ERROR :'||SQLERRM);

Line 1607: pa_cc_utils.reset_curr_function;

1603: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1604: DELETE from GMS_DISTRIBUTIONS
1605: where document_header_id = p_xface_id ;
1606: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1607: pa_cc_utils.reset_curr_function;
1608: EXCEPTION
1609: When others then
1610: pa_cc_utils.log_message(' ERROR :'||SQLERRM);
1611: pa_cc_utils.reset_curr_function;

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

1606: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1607: pa_cc_utils.reset_curr_function;
1608: EXCEPTION
1609: When others then
1610: pa_cc_utils.log_message(' ERROR :'||SQLERRM);
1611: pa_cc_utils.reset_curr_function;
1612: RAISE ;
1613: END PROC_INSERT_TRANS ;
1614:

Line 1611: pa_cc_utils.reset_curr_function;

1607: pa_cc_utils.reset_curr_function;
1608: EXCEPTION
1609: When others then
1610: pa_cc_utils.log_message(' ERROR :'||SQLERRM);
1611: pa_cc_utils.reset_curr_function;
1612: RAISE ;
1613: END PROC_INSERT_TRANS ;
1614:
1615: -- ============

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

1617: , batch VARCHAR2
1618: , etypeclasscode VARCHAR2 ) RETURN NUMBER IS
1619: dummy NUMBER ;
1620: BEGIN
1621: pa_cc_utils.set_curr_function('Award Distribution lockCntrlRec');
1622:
1623: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||
1624: ' transaction source ='||trx_source||
1625: ' batch = '||batch||

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

1619: dummy NUMBER ;
1620: BEGIN
1621: pa_cc_utils.set_curr_function('Award Distribution lockCntrlRec');
1622:
1623: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||
1624: ' transaction source ='||trx_source||
1625: ' batch = '||batch||
1626: ' sys link = '||etypeclasscode, 1);
1627: SELECT 1

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

1632: AND system_linkage_function = etypeclasscode
1633: AND status = 'PENDING'
1634: FOR UPDATE OF status NOWAIT;
1635:
1636: pa_cc_utils.log_message('Got lock for record',1);
1637: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1638: pa_cc_utils.reset_curr_function;
1639:
1640: RETURN 0;

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

1633: AND status = 'PENDING'
1634: FOR UPDATE OF status NOWAIT;
1635:
1636: pa_cc_utils.log_message('Got lock for record',1);
1637: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1638: pa_cc_utils.reset_curr_function;
1639:
1640: RETURN 0;
1641: EXCEPTION

Line 1638: pa_cc_utils.reset_curr_function;

1634: FOR UPDATE OF status NOWAIT;
1635:
1636: pa_cc_utils.log_message('Got lock for record',1);
1637: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1638: pa_cc_utils.reset_curr_function;
1639:
1640: RETURN 0;
1641: EXCEPTION
1642: WHEN RESOURCE_BUSY THEN

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

1639:
1640: RETURN 0;
1641: EXCEPTION
1642: WHEN RESOURCE_BUSY THEN
1643: pa_cc_utils.log_message('Cannot get lock',1);
1644: pa_cc_utils.reset_curr_function;
1645: RETURN -1;
1646: END lockCntrlRec;
1647:

Line 1644: pa_cc_utils.reset_curr_function;

1640: RETURN 0;
1641: EXCEPTION
1642: WHEN RESOURCE_BUSY THEN
1643: pa_cc_utils.log_message('Cannot get lock',1);
1644: pa_cc_utils.reset_curr_function;
1645: RETURN -1;
1646: END lockCntrlRec;
1647:
1648:

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

1659: PROCEDURE GET_DIST_AWARD_ID( p_default_dist_award_id out NOCOPY NUMBER,
1660: p_default_dist_award_number out NOCOPY varchar2,
1661: p_status out NOCOPY varchar2) IS
1662: BEGIN
1663: pa_cc_utils.set_curr_function('Award Distribution GET_DIST_AWARD_ID');
1664:
1665: SELECT default_dist_award_id,
1666: default_dist_award_number -- Bug 3221039
1667: INTO p_default_dist_award_id,

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

1668: p_default_dist_award_number -- Bug 3221039
1669: FROM GMS_IMPLEMENTATIONS
1670: WHERE AWARD_DISTRIBUTION_OPTION = 'Y' ;
1671:
1672: pa_cc_utils.log_message('Award Distribution default_dist_award_id='||to_char(p_default_dist_award_id));
1673: pa_cc_utils.reset_curr_function;
1674:
1675: --return x_dummy ;
1676: EXCEPTION

Line 1673: pa_cc_utils.reset_curr_function;

1669: FROM GMS_IMPLEMENTATIONS
1670: WHERE AWARD_DISTRIBUTION_OPTION = 'Y' ;
1671:
1672: pa_cc_utils.log_message('Award Distribution default_dist_award_id='||to_char(p_default_dist_award_id));
1673: pa_cc_utils.reset_curr_function;
1674:
1675: --return x_dummy ;
1676: EXCEPTION
1677: when no_data_found then

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

1675: --return x_dummy ;
1676: EXCEPTION
1677: when no_data_found then
1678: p_status := 'NO_DATA_FOUND' ;
1679: pa_cc_utils.log_message('Award Distribution default_dist_award_id not enabled.****');
1680: pa_cc_utils.reset_curr_function;
1681: --return -1 ;
1682: END GET_DIST_AWARD_ID ;
1683: -- ==== End of GET_DIST_AWARD_ID ==================================

Line 1680: pa_cc_utils.reset_curr_function;

1676: EXCEPTION
1677: when no_data_found then
1678: p_status := 'NO_DATA_FOUND' ;
1679: pa_cc_utils.log_message('Award Distribution default_dist_award_id not enabled.****');
1680: pa_cc_utils.reset_curr_function;
1681: --return -1 ;
1682: END GET_DIST_AWARD_ID ;
1683: -- ==== End of GET_DIST_AWARD_ID ==================================
1684:

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

1941: x_record_found := 0 ;
1942: l_project_id_last := 0 ;
1943: l_task_id_last := 0 ;
1944:
1945: pa_cc_utils.set_curr_function('PRE_IMPORT');
1946: pa_cc_utils.log_message('Start Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1947:
1948: -- Bug 3221039 : Modified the call to procedure from function
1949: --x_default_dist_award_id := get_dist_award_id(x_status) ;

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

1942: l_project_id_last := 0 ;
1943: l_task_id_last := 0 ;
1944:
1945: pa_cc_utils.set_curr_function('PRE_IMPORT');
1946: pa_cc_utils.log_message('Start Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1947:
1948: -- Bug 3221039 : Modified the call to procedure from function
1949: --x_default_dist_award_id := get_dist_award_id(x_status) ;
1950: get_dist_award_id(x_default_dist_award_id,l_default_dist_award_number,x_status);

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

1956: -- to continue further.
1957: -- =====================================================
1958:
1959: IF x_status is not NULL THEN
1960: pa_cc_utils.log_message('Award Distribution not enabled, pre-import Exit.');
1961: pa_cc_utils.reset_curr_function;
1962: return ;
1963: END IF ;
1964:

Line 1961: pa_cc_utils.reset_curr_function;

1957: -- =====================================================
1958:
1959: IF x_status is not NULL THEN
1960: pa_cc_utils.log_message('Award Distribution not enabled, pre-import Exit.');
1961: pa_cc_utils.reset_curr_function;
1962: return ;
1963: END IF ;
1964:
1965: x_record_found := 0 ;

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

1975:
1976: dummy := lockCntrlRec( eachGroup.transaction_source , eachGroup.batch_name
1977: , eachGroup.system_linkage_function );
1978: IF ( dummy <> 0 ) THEN
1979: pa_cc_utils.log_message(eachGroup.batch_name||' : All records rejected because of :'||'LOCK_'||eachGroup.batch_name||'_FAILED');
1980:
1981: UPDATE pa_transaction_interface
1982: SET transaction_rejection_code = 'LOCK_'||eachGroup.batch_name||'_FAILED'
1983: , transaction_status_code = 'PR'

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

1984: WHERE transaction_source = eachGroup.transaction_source
1985: AND batch_name = eachGroup.batch_name
1986: AND transaction_status_code = 'P';
1987:
1988: pa_cc_utils.log_message(eachGroup.batch_name||' : Rejected Count :'||to_char(SQL%ROWCOUNT));
1989:
1990: END IF ;
1991: -- =======End of LOCK CHECK ********
1992:

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

1992:
1993:
1994: OPEN TrxRecs( eachGroup.transaction_source , eachGroup.batch_name , eachGroup.system_linkage_function );
1995:
1996: pa_cc_utils.log_message('Fetch Records for :'||eachGroup.transaction_source||','||eachGroup.batch_name||','
1997: ||eachGroup.system_linkage_function ) ;
1998:
1999: FIRST_RECORD := TRUE ;
2000:

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

2037: l_task_number := TrxRec.task_number ;
2038: l_project_number := TrxRec.Project_number ;
2039:
2040: IF ( TrxRecs%ROWCOUNT = 0 ) THEN
2041: pa_cc_utils.log_message('Zero Records Fetched',1);
2042: EXIT expenditures ;
2043: ELSIF ( TrxRecs%NOTFOUND ) THEN
2044: pa_cc_utils.log_message('Last Record fetched',1);
2045: EXIT expenditures ;

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

2040: IF ( TrxRecs%ROWCOUNT = 0 ) THEN
2041: pa_cc_utils.log_message('Zero Records Fetched',1);
2042: EXIT expenditures ;
2043: ELSIF ( TrxRecs%NOTFOUND ) THEN
2044: pa_cc_utils.log_message('Last Record fetched',1);
2045: EXIT expenditures ;
2046: END IF;
2047: --
2048: -- bug : 3628820 perf issue in gmsawdeb.pls

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

2050: --
2051: IF l_project_number is NULL and l_project_id is NOT NULL THEN
2052:
2053: IF l_project_id_last <> l_project_id THEN
2054: pa_cc_utils.log_message('GMS: Pre_import open c_project_number.');
2055: open c_project_number ;
2056: fetch c_project_number into l_project_number ;
2057: close c_project_number ;
2058:

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

2080: IF l_project_number is not NULL and l_project_id is NULL THEN
2081: IF l_project_number_last <> l_project_number OR
2082: l_project_number_last is NULL THEN
2083:
2084: pa_cc_utils.log_message('GMS: Pre_import open c_project_id.');
2085: open c_project_id ;
2086: fetch c_project_id into l_project_id ;
2087: close c_project_id ;
2088:

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

2116: IF l_task_number is NULL and l_task_id is NOT NULL THEN
2117: IF l_task_id_last <> l_task_id OR
2118: l_task_id_last is NULL THEN
2119:
2120: pa_cc_utils.log_message('GMS: Pre_import open c_task_number.');
2121: open c_task_number ;
2122: fetch c_task_number into l_task_number ;
2123: close c_task_number ;
2124:

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

2138: IF l_task_number is not NULL and l_task_id is NULL THEN
2139: IF l_task_number_last <> l_task_number OR
2140: l_task_number_last is NULL THEN
2141:
2142: pa_cc_utils.log_message('GMS: Pre_import open c_task_id.');
2143: open c_task_id ;
2144: fetch c_task_id into l_task_id ;
2145: close c_task_id ;
2146: -- 5169675

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

2191: -- bug:5131439 TRANSACTION IMORT FAILED WITH PA_EXP_INV_PJTK FOR LEGITIMATE
2192: --x_status := NULL ;
2193: --
2194:
2195: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2196: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2197: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:

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

2192: --x_status := NULL ;
2193: --
2194:
2195: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2196: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2197: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);

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

2193: --
2194:
2195: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2196: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2197: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2201: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);

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

2194:
2195: pa_cc_utils.log_message('GMS: Pre_import l_project_id :'|| l_project_id);
2196: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2197: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2201: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2202: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);

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

2196: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_id_last);
2197: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2201: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2202: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2203: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2204: --

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

2197: pa_cc_utils.log_message('GMS: Pre_import l_project_number :'|| l_project_number);
2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2201: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2202: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2203: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2204: --
2205: -- bug : 3628820 perf issue in gmsawdeb.pls

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

2198: pa_cc_utils.log_message('GMS: Pre_import l_project_id_last :'|| l_project_number_last);
2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2201: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2202: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2203: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2204: --
2205: -- bug : 3628820 perf issue in gmsawdeb.pls
2206: -- FTS on pa_projects and pa_tasks table.

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

2199:
2200: pa_cc_utils.log_message('GMS: Pre_import l_task_id :'|| l_task_id);
2201: pa_cc_utils.log_message('GMS: Pre_import l_task_id_last :'|| l_task_id_last);
2202: pa_cc_utils.log_message('GMS: Pre_import l_task_number :'|| l_task_number);
2203: pa_cc_utils.log_message('GMS: Pre_import l_task_number_last :'|| l_task_number_last);
2204: --
2205: -- bug : 3628820 perf issue in gmsawdeb.pls
2206: -- FTS on pa_projects and pa_tasks table.
2207: --

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

2212:
2213: IF X_status is NULL THEN
2214: pa_debug.G_err_stage := 'CAlling ValidateOrgId';
2215:
2216: pa_cc_utils.log_message(pa_debug.G_err_stage);
2217:
2218: PA_TRX_IMPORT.ValidateOrgId(TrxRec.org_id,X_org_status );
2219: END IF ;
2220: IF ( X_org_status IS NOT NULL ) THEN

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

2222: X_status := X_org_status;
2223: ELSE
2224: -- org id is not null. continue with other validations
2225: pa_debug.G_err_stage := 'CAlling ValidateItem';
2226: pa_cc_utils.log_message(pa_debug.G_err_stage);
2227: l_emporg_id := NULL ;
2228: l_empjob_id := NULL ;
2229:
2230: IF NVL(l_emp_org_oride, 'N') = 'N' AND

Line 2324: pa_cc_utils.reset_curr_function;

2320: , TrxRec.person_type
2321: , TrxRec.po_price_type
2322: );
2323:
2324: pa_cc_utils.reset_curr_function;
2325:
2326: END IF ;
2327:
2328: IF ( X_status IS NOT NULL ) THEN

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

2328: IF ( X_status IS NOT NULL ) THEN
2329:
2330: pa_debug.G_err_stage := 'Updating txn interface table for txn'||
2331: ' rejected by validateitem';
2332: pa_cc_utils.log_message(pa_debug.G_err_stage);
2333:
2334: UPDATE pa_transaction_interface
2335: SET transaction_rejection_code = X_status ,
2336: interface_id = P_xface_id ,

Line 2340: pa_cc_utils.reset_curr_function;

2336: interface_id = P_xface_id ,
2337: transaction_status_code = 'PR'
2338: WHERE CURRENT OF TrxRecs;
2339:
2340: pa_cc_utils.reset_curr_function;
2341: ELSE
2342: -- =================================================
2343: -- Identify the record for distribution.
2344: -- ================================================

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

2455: SYSDATE
2456: ) ;
2457: END LOOP ;
2458:
2459: pa_cc_utils.log_message('Insert record into gms_distributions :'||to_char(count_rec));
2460: -- =====================================
2461: -- There is nothing to distribute.
2462: -- =====================================
2463: IF x_record_found = 0 THEN

Line 2464: pa_cc_utils.reset_curr_function;

2460: -- =====================================
2461: -- There is nothing to distribute.
2462: -- =====================================
2463: IF x_record_found = 0 THEN
2464: pa_cc_utils.reset_curr_function;
2465: pa_cc_utils.log_message('Nothing found for distributions -PRE_IMPORT EXIT');
2466: return ;
2467: END IF ;
2468: -- =================================================

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

2461: -- There is nothing to distribute.
2462: -- =====================================
2463: IF x_record_found = 0 THEN
2464: pa_cc_utils.reset_curr_function;
2465: pa_cc_utils.log_message('Nothing found for distributions -PRE_IMPORT EXIT');
2466: return ;
2467: END IF ;
2468: -- =================================================
2469: -- Distribute records using FAB engine.

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

2467: END IF ;
2468: -- =================================================
2469: -- Distribute records using FAB engine.
2470: -- =================================================
2471: pa_cc_utils.log_message('Start gms_award_dist_eng.proc_distribute_records '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2472:
2473: gms_award_dist_eng.proc_distribute_records(p_xface_id,
2474: 'EXP',
2475: x_accepted,

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

2473: gms_award_dist_eng.proc_distribute_records(p_xface_id,
2474: 'EXP',
2475: x_accepted,
2476: x_rejected ) ;
2477: pa_cc_utils.log_message('End gms_award_dist_eng.proc_distribute_records '||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2478: -- ==================================================
2479: -- Update 1st distribution into IMPORT tables.
2480: -- ==================================================
2481: -- 3466152

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

2504: where C.document_header_id = P_xface_id
2505: and C.distribution_number= 1
2506: and C.document_type = 'EXP' );
2507:
2508: pa_cc_utils.log_message('Update award_id in gms_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2509:
2510: -- 3466152
2511: -- import process award distributions doesn't work when batch name is not supplied.
2512: -- removed batch name criteria . Its not needed since txn_interface_id is available.

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

2533: WHERE C.document_header_id = P_xface_id
2534: and C.distribution_number= 1
2535: and C.document_type = 'EXP' );
2536:
2537: pa_cc_utils.log_message('Update ( quantity, raw_cost ) in pa_transaction_interface_all count :'||
2538: to_char(SQL%ROWCOUNT));
2539: -- 3466152
2540: -- import process award distributions doesn't work when batch name is not supplied.
2541: -- removed batch name criteria . Its not needed since txn_interface_id is available.

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

2556: WHERE B.document_header_id = P_Xface_id
2557: and B.document_type = 'EXP'
2558: and NVL(B.dist_status,'X') <> 'FABA' ) ;
2559:
2560: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2561: -- ===================================================================
2562: -- Insert distributed records into PA_transaction_interface_all and
2563: -- gms_transaction_interface_all. Update the count in
2564: -- pa_transaction_xface_ctrl_all

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

2566: PROC_INSERT_TRANS( P_transaction_source,
2567: p_batch ,
2568: p_user_id ,
2569: p_xface_id ) ;
2570: pa_cc_utils.log_message('END Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2571: pa_cc_utils.reset_curr_function;
2572: EXCEPTION
2573: When OTHERS THEN
2574:

Line 2571: pa_cc_utils.reset_curr_function;

2567: p_batch ,
2568: p_user_id ,
2569: p_xface_id ) ;
2570: pa_cc_utils.log_message('END Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2571: pa_cc_utils.reset_curr_function;
2572: EXCEPTION
2573: When OTHERS THEN
2574:
2575: IF TrxRecs%Isopen THEN

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

2575: IF TrxRecs%Isopen THEN
2576: Close TrxRecs ;
2577: END IF ;
2578:
2579: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2580: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);
2581: pa_cc_utils.reset_curr_function;
2582: ROLLBACK ;
2583: raise_application_error( -20000, SQLERRM ) ;

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

2576: Close TrxRecs ;
2577: END IF ;
2578:
2579: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2580: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);
2581: pa_cc_utils.reset_curr_function;
2582: ROLLBACK ;
2583: raise_application_error( -20000, SQLERRM ) ;
2584: RAISE ;

Line 2581: pa_cc_utils.reset_curr_function;

2577: END IF ;
2578:
2579: pa_cc_utils.log_message('ERROR Grants Accounting Pre Import for award Distributions.'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2580: pa_cc_utils.log_message('PLSQL ERROR Occured :'||SQLERRM);
2581: pa_cc_utils.reset_curr_function;
2582: ROLLBACK ;
2583: raise_application_error( -20000, SQLERRM ) ;
2584: RAISE ;
2585: END PRE_IMPORT ;