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.PA_TRANSACTIONS dependencies on PA_CC_UTILS

Line 4: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode;

1: PACKAGE BODY PA_TRANSACTIONS AS
2: /* $Header: PAXTRANB.pls 120.10.12000000.4 2007/04/10 12:08:36 srachako ship $ */
3:
4: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode;
5:
6:
7: -- ========================================================================
8: -- PROCEDURE LoadEi

Line 139: pa_cc_utils.set_curr_function('LoadEi');

135: , p_cdlsr5 IN number default NULL
136: ) IS
137: BEGIN
138: -- dbms_output.put_line('In Loadei:'||to_char(i));
139: pa_cc_utils.set_curr_function('LoadEi');
140: IF P_DEBUG_MODE THEN
141: pa_cc_utils.log_message('LoadEi: ' || 'Start ');
142: END IF;
143:

Line 141: pa_cc_utils.log_message('LoadEi: ' || 'Start ');

137: BEGIN
138: -- dbms_output.put_line('In Loadei:'||to_char(i));
139: pa_cc_utils.set_curr_function('LoadEi');
140: IF P_DEBUG_MODE THEN
141: pa_cc_utils.log_message('LoadEi: ' || 'Start ');
142: END IF;
143:
144: EiIdTab(i) := X_expenditure_item_id;
145: EIdTab(i) := X_expenditure_id;

Line 293: pa_cc_utils.log_message('LoadEi: ' || 'End ');

289:
290: SrcEtypeClassTab(i) := p_src_system_linkage_function; /* 4057874 */
291:
292: IF P_DEBUG_MODE THEN
293: pa_cc_utils.log_message('LoadEi: ' || 'End ');
294: END IF;
295: pa_cc_utils.reset_curr_function ;
296: END LoadEi;
297:

Line 295: pa_cc_utils.reset_curr_function ;

291:
292: IF P_DEBUG_MODE THEN
293: pa_cc_utils.log_message('LoadEi: ' || 'End ');
294: END IF;
295: pa_cc_utils.reset_curr_function ;
296: END LoadEi;
297:
298:
299: -- ========================================================================

Line 306: pa_cc_utils.set_curr_function('FlushEiTabs');

302:
303: PROCEDURE FlushEiTabs
304: IS
305: BEGIN
306: pa_cc_utils.set_curr_function('FlushEiTabs');
307: pa_cc_utils.log_message('Start ');
308:
309: EiIdTab := pa_utils.EmptyIdTab;
310: EIdTab := pa_utils.EmptyIdTab;

Line 307: pa_cc_utils.log_message('Start ');

303: PROCEDURE FlushEiTabs
304: IS
305: BEGIN
306: pa_cc_utils.set_curr_function('FlushEiTabs');
307: pa_cc_utils.log_message('Start ');
308:
309: EiIdTab := pa_utils.EmptyIdTab;
310: EIdTab := pa_utils.EmptyIdTab;
311: TskIdTab := pa_utils.EmptyIdTab;

Line 456: pa_cc_utils.log_message('End ');

452: Cdlsr5Tab := pa_utils.EmptyIdTab ;
453:
454: /* REL12-AP Lines uptake END*/
455:
456: pa_cc_utils.log_message('End ');
457: pa_cc_utils.reset_curr_function ;
458:
459: END FlushEiTabs;
460:

Line 457: pa_cc_utils.reset_curr_function ;

453:
454: /* REL12-AP Lines uptake END*/
455:
456: pa_cc_utils.log_message('End ');
457: pa_cc_utils.reset_curr_function ;
458:
459: END FlushEiTabs;
460:
461:

Line 474: pa_cc_utils.set_curr_function('InsItemComment');

470: , X_login IN NUMBER
471: , X_status OUT NOCOPY NUMBER )
472: IS
473: BEGIN
474: pa_cc_utils.set_curr_function('InsItemComment');
475: IF P_DEBUG_MODE THEN
476: pa_cc_utils.log_message('InsItemComment: ' || 'Start ');
477: END IF;
478:

Line 476: pa_cc_utils.log_message('InsItemComment: ' || 'Start ');

472: IS
473: BEGIN
474: pa_cc_utils.set_curr_function('InsItemComment');
475: IF P_DEBUG_MODE THEN
476: pa_cc_utils.log_message('InsItemComment: ' || 'Start ');
477: END IF;
478:
479: INSERT INTO pa_expenditure_comments (
480: expenditure_item_id

Line 500: pa_cc_utils.log_message('InsItemComment: ' || 'End ');

496: , X_login ); -- last_update_login
497:
498: X_status := 0;
499: IF P_DEBUG_MODE THEN
500: pa_cc_utils.log_message('InsItemComment: ' || 'End ');
501: END IF;
502: pa_cc_utils.reset_curr_function ;
503:
504: EXCEPTION

Line 502: pa_cc_utils.reset_curr_function ;

498: X_status := 0;
499: IF P_DEBUG_MODE THEN
500: pa_cc_utils.log_message('InsItemComment: ' || 'End ');
501: END IF;
502: pa_cc_utils.reset_curr_function ;
503:
504: EXCEPTION
505: WHEN OTHERS THEN
506: X_status := SQLCODE;

Line 558: pa_cc_utils.set_curr_function('InsItems');

554: BackoutItemID pa_utils.IdTabTyp; -- Bug 5501593
555: item_comment VARCHAR2(240); -- Bug 5501593
556:
557: BEGIN
558: pa_cc_utils.set_curr_function('InsItems');
559: IF P_DEBUG_MODE THEN
560: pa_cc_utils.log_message('InsItems: ' || 'Start ');
561: END IF;
562:

Line 560: pa_cc_utils.log_message('InsItems: ' || 'Start ');

556:
557: BEGIN
558: pa_cc_utils.set_curr_function('InsItems');
559: IF P_DEBUG_MODE THEN
560: pa_cc_utils.log_message('InsItems: ' || 'Start ');
561: END IF;
562:
563: /* Bug Fix: 3258043 If the transaction import process calls insItems with gl_accounted_flag = 'Y'
564: * then donot override the GL period information

Line 574: pa_cc_utils.log_message('InsItems: ' || 'Start of bulk insert for EI insertion');

570: X_program_application_id := FND_GLOBAL.PROG_APPL_ID ;
571:
572: --PA-K Changes: Modified EI insert into bulk insert
573: IF P_DEBUG_MODE THEN
574: pa_cc_utils.log_message('InsItems: ' || 'Start of bulk insert for EI insertion');
575: END IF;
576: FORALL i IN 1..Rows ---{
577: INSERT INTO pa_expenditure_items_all (
578: expenditure_item_id

Line 836: pa_cc_utils.log_message('InsItems: ' || 'End of bulk insert for EI insertion');

832: /* REL12-AP Lines uptake END*/
833: ); ---}
834:
835: IF P_DEBUG_MODE THEN
836: pa_cc_utils.log_message('InsItems: ' || 'End of bulk insert for EI insertion');
837: END IF;
838:
839: FOR i IN 1..Rows LOOP ---{
840: IF P_DEBUG_MODE THEN

Line 841: pa_cc_utils.log_message('InsItems: ' || 'Start of Loop for CDL insertion');

837: END IF;
838:
839: FOR i IN 1..Rows LOOP ---{
840: IF P_DEBUG_MODE THEN
841: pa_cc_utils.log_message('InsItems: ' || 'Start of Loop for CDL insertion');
842: END IF;
843:
844: /* #1978887: In case of Supplier Invoices which are interfaced to Projects,
845: Cost_Burden_Distributed_Flag should be set to 'N' only if the corresponding project

Line 868: pa_cc_utils.log_message('InsItems: ' || 'After Insert');

864: --PA-K For GL Accoutned Txns, call CDL creation API row by row
865: IF nvl(X_gl_flag,'N') in ('Y', 'P') THEN ---{
866:
867: IF P_DEBUG_MODE THEN
868: pa_cc_utils.log_message('InsItems: ' || 'After Insert');
869: END IF;
870:
871: -- Added the following function call to calculate pa_date to Resolve Bug 1103257 base bug 967390
872:

Line 1008: pa_cc_utils.log_message('InsItems: ' || 'After Creation of CDL');

1004: , p_cdlsr5 => Cdlsr5Tab(i)
1005: );
1006:
1007: IF P_DEBUG_MODE THEN
1008: pa_cc_utils.log_message('InsItems: ' || 'After Creation of CDL');
1009: END IF;
1010:
1011: END IF ; ---}
1012:

Line 1016: pa_cc_utils.reset_curr_function ;

1012:
1013: -- dbms_output.put_line( 'error code : ' || to_char( x_err_code)) ;
1014: IF X_err_code <> 0 THEN
1015: x_status := x_err_code ;
1016: pa_cc_utils.reset_curr_function ;
1017: RETURN ;
1018: END IF ;
1019:
1020: IF ( EiCommentTab(i) IS NOT NULL ) THEN

Line 1033: pa_cc_utils.log_message('Trx Import call to InsItems');

1029: END IF;
1030:
1031: IF ( X_calling_process = 'TRX_IMPORT' ) THEN
1032: IF P_DEBUG_MODE THEN
1033: pa_cc_utils.log_message('Trx Import call to InsItems');
1034: END IF;
1035:
1036: IF ( AdjEiTab(i) IS NOT NULL ) THEN ---{
1037:

Line 1045: pa_cc_utils.log_message('InsItems: ' || 'After call to InsAuditRec');

1041: , X_user => X_user
1042: , X_login => X_login
1043: , X_status => temp_status );
1044: IF P_DEBUG_MODE THEN
1045: pa_cc_utils.log_message('InsItems: ' || 'After call to InsAuditRec');
1046: END IF;
1047:
1048: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1049:

Line 1070: pa_cc_utils.log_message('InsItems: ' || 'After call to SetNetZero');

1066: , X_user => X_user
1067: , X_login => X_login
1068: , X_status => temp_status );
1069: IF P_DEBUG_MODE THEN
1070: pa_cc_utils.log_message('InsItems: ' || 'After call to SetNetZero');
1071: END IF;
1072:
1073: -- R12 AP Lines uptake
1074: -- SLA need to have parent line_num populated with the latest cdl line

Line 1100: pa_cc_utils.log_message('InsItems: ' || 'After call to ReverseRelatedItems');

1096: , X_user => X_user
1097: , X_login => X_login
1098: , X_status => temp_status );
1099: IF P_DEBUG_MODE THEN
1100: pa_cc_utils.log_message('InsItems: ' || 'After call to ReverseRelatedItems');
1101: END IF;
1102:
1103: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1104:

Line 1443: pa_cc_utils.log_message('InsItems: ' || 'End ');

1439: /* Bug 5501593 - End */
1440:
1441: X_status := 0;
1442: IF P_DEBUG_MODE THEN
1443: pa_cc_utils.log_message('InsItems: ' || 'End ');
1444: END IF;
1445: pa_cc_utils.reset_curr_function ;
1446:
1447: EXCEPTION

Line 1445: pa_cc_utils.reset_curr_function ;

1441: X_status := 0;
1442: IF P_DEBUG_MODE THEN
1443: pa_cc_utils.log_message('InsItems: ' || 'End ');
1444: END IF;
1445: pa_cc_utils.reset_curr_function ;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: X_status := SQLCODE;

Line 1498: pa_cc_utils.set_curr_function('InsertExp');

1494: , P_Org_ID IN NUMBER -- 12i MOAC changes
1495: )
1496: IS
1497: BEGIN
1498: pa_cc_utils.set_curr_function('InsertExp');
1499: IF P_DEBUG_MODE THEN
1500: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1501: END IF;
1502: INSERT INTO pa_expenditures(

Line 1500: pa_cc_utils.log_message('InsertExp: ' || 'Start ');

1496: IS
1497: BEGIN
1498: pa_cc_utils.set_curr_function('InsertExp');
1499: IF P_DEBUG_MODE THEN
1500: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1501: END IF;
1502: INSERT INTO pa_expenditures(
1503: expenditure_id
1504: , expenditure_status_code

Line 1581: pa_cc_utils.log_message('InsertExp: ' || 'End ');

1577: , X_orig_exp_txn_reference3
1578: , X_person_type
1579: , P_Org_Id); -- 12i MOAC changes
1580: IF P_DEBUG_MODE THEN
1581: pa_cc_utils.log_message('InsertExp: ' || 'End ');
1582: END IF;
1583: pa_cc_utils.reset_curr_function ;
1584:
1585: END InsertExp;

Line 1583: pa_cc_utils.reset_curr_function ;

1579: , P_Org_Id); -- 12i MOAC changes
1580: IF P_DEBUG_MODE THEN
1581: pa_cc_utils.log_message('InsertExp: ' || 'End ');
1582: END IF;
1583: pa_cc_utils.reset_curr_function ;
1584:
1585: END InsertExp;
1586:
1587:

Line 1599: pa_cc_utils.set_curr_function('InsertExpGroup');

1595: , P_accrual_flag IN VARCHAR2
1596: , P_Org_Id IN NUMBER) -- 12i MOAC changes
1597: IS
1598: BEGIN
1599: pa_cc_utils.set_curr_function('InsertExpGroup');
1600: IF P_DEBUG_MODE THEN
1601: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1602: END IF;
1603:

Line 1601: pa_cc_utils.log_message('InsertExp: ' || 'Start ');

1597: IS
1598: BEGIN
1599: pa_cc_utils.set_curr_function('InsertExpGroup');
1600: IF P_DEBUG_MODE THEN
1601: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1602: END IF;
1603:
1604: INSERT INTO pa_expenditure_groups(
1605: expenditure_group

Line 1628: pa_cc_utils.log_message('InsertExp: ' || 'End ');

1624: , X_transaction_source
1625: , P_accrual_flag
1626: , P_Org_Id); -- 12i MOAC changes
1627: IF P_DEBUG_MODE THEN
1628: pa_cc_utils.log_message('InsertExp: ' || 'End ');
1629: END IF;
1630: pa_cc_utils.reset_curr_function ;
1631:
1632: END InsertExpGroup;

Line 1630: pa_cc_utils.reset_curr_function ;

1626: , P_Org_Id); -- 12i MOAC changes
1627: IF P_DEBUG_MODE THEN
1628: pa_cc_utils.log_message('InsertExp: ' || 'End ');
1629: END IF;
1630: pa_cc_utils.reset_curr_function ;
1631:
1632: END InsertExpGroup;
1633:
1634: --PA-K Changes

Line 1650: pa_cc_utils.set_curr_function('InsertExpGroupNew');

1646: l_Dummy NUMBER;
1647: l_Ending_Date DATE;
1648:
1649: BEGIN
1650: pa_cc_utils.set_curr_function('InsertExpGroupNew');
1651: IF P_DEBUG_MODE THEN
1652: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1653: END IF;
1654:

Line 1652: pa_cc_utils.log_message('InsertExp: ' || 'Start ');

1648:
1649: BEGIN
1650: pa_cc_utils.set_curr_function('InsertExpGroupNew');
1651: IF P_DEBUG_MODE THEN
1652: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1653: END IF;
1654:
1655: Begin
1656:

Line 1658: pa_cc_utils.log_message('InsertExp: ' || 'Selecting if the group already exists');

1654:
1655: Begin
1656:
1657: IF P_DEBUG_MODE THEN
1658: pa_cc_utils.log_message('InsertExp: ' || 'Selecting if the group already exists');
1659: END IF;
1660:
1661: select 1, expenditure_ending_date
1662: into l_Dummy, l_Ending_Date

Line 1669: pa_cc_utils.log_message('InsertExp: ' || 'no data found when selecting if group already exists');

1665:
1666: Exception
1667: when no_data_found then
1668: IF P_DEBUG_MODE THEN
1669: pa_cc_utils.log_message('InsertExp: ' || 'no data found when selecting if group already exists');
1670: END IF;
1671: l_dummy := 0 ;
1672:
1673: End;

Line 1677: pa_cc_utils.log_message('InsertExp: ' || 'Exp Group does not exist, insert');

1673: End;
1674:
1675: If (l_dummy = 0) Then
1676: IF P_DEBUG_MODE THEN
1677: pa_cc_utils.log_message('InsertExp: ' || 'Exp Group does not exist, insert');
1678: END IF;
1679:
1680: INSERT INTO pa_expenditure_groups(
1681: expenditure_group

Line 1707: pa_cc_utils.log_message('InsertExp: ' || 'Exp Group does exist, update if needed');

1703:
1704: Else
1705:
1706: IF P_DEBUG_MODE THEN
1707: pa_cc_utils.log_message('InsertExp: ' || 'Exp Group does exist, update if needed');
1708: END IF;
1709:
1710: If trunc(X_ending_date) > trunc(l_Ending_Date) Then
1711:

Line 1713: pa_cc_utils.log_message('InsertExp: ' || 'Existing Exp Groups ending date is lesser, update');

1709:
1710: If trunc(X_ending_date) > trunc(l_Ending_Date) Then
1711:
1712: IF P_DEBUG_MODE THEN
1713: pa_cc_utils.log_message('InsertExp: ' || 'Existing Exp Groups ending date is lesser, update');
1714: END IF;
1715:
1716: update pa_expenditure_groups
1717: set expenditure_ending_date = X_ending_date

Line 1721: pa_cc_utils.log_message('InsertExp: ' || 'Updated Count = '||SQL%ROWCOUNT);

1717: set expenditure_ending_date = X_ending_date
1718: where expenditure_group = X_expenditure_group;
1719:
1720: IF P_DEBUG_MODE THEN
1721: pa_cc_utils.log_message('InsertExp: ' || 'Updated Count = '||SQL%ROWCOUNT);
1722: END IF;
1723:
1724: End If;
1725:

Line 1729: pa_cc_utils.log_message('InsertExp: ' || 'End ');

1725:
1726: End If;
1727:
1728: IF P_DEBUG_MODE THEN
1729: pa_cc_utils.log_message('InsertExp: ' || 'End ');
1730: END IF;
1731: pa_cc_utils.reset_curr_function ;
1732:
1733: END InsertExpGroupNew;

Line 1731: pa_cc_utils.reset_curr_function ;

1727:
1728: IF P_DEBUG_MODE THEN
1729: pa_cc_utils.log_message('InsertExp: ' || 'End ');
1730: END IF;
1731: pa_cc_utils.reset_curr_function ;
1732:
1733: END InsertExpGroupNew;
1734:
1735:

Line 1815: pa_cc_utils.set_curr_function('CreateRelatedItem');

1811: source_award_id NUMBER ; /*added for bug 5769510*/
1812:
1813:
1814: BEGIN
1815: pa_cc_utils.set_curr_function('CreateRelatedItem');
1816: IF P_DEBUG_MODE THEN
1817: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Start ');
1818: END IF;
1819:

Line 1817: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Start ');

1813:
1814: BEGIN
1815: pa_cc_utils.set_curr_function('CreateRelatedItem');
1816: IF P_DEBUG_MODE THEN
1817: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Start ');
1818: END IF;
1819:
1820: l_gms_enabled := gms_pa_costing_pkg.grants_implemented;
1821:

Line 1834: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Invalid Work Type Name');

1830: exception
1831: when no_data_found then
1832: X_status := 10;
1833: IF P_DEBUG_MODE THEN
1834: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Invalid Work Type Name');
1835: END IF;
1836: pa_cc_utils.reset_curr_function ;
1837: X_outcome := 'INVALID_WORK_TYPE';
1838: return;

Line 1836: pa_cc_utils.reset_curr_function ;

1832: X_status := 10;
1833: IF P_DEBUG_MODE THEN
1834: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Invalid Work Type Name');
1835: END IF;
1836: pa_cc_utils.reset_curr_function ;
1837: X_outcome := 'INVALID_WORK_TYPE';
1838: return;
1839: end;
1840:

Line 1843: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Work Type ID defaults from source EI');

1839: end;
1840:
1841: else
1842: IF P_DEBUG_MODE THEN
1843: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Work Type ID defaults from source EI');
1844: END IF;
1845: select work_type_id
1846: into l_work_type_id
1847: from pa_expenditure_items

Line 1918: pa_cc_utils.log_message('In pa_transactions.CreateRelatedItem: After select statement');

1914: e.expenditure_id = ei.expenditure_id
1915: AND ei.expenditure_item_id = X_source_exp_item_id
1916: AND ei.task_id = t.task_id;
1917: IF P_DEBUG_MODE THEN
1918: pa_cc_utils.log_message('In pa_transactions.CreateRelatedItem: After select statement');
1919: END IF;
1920:
1921: IF ( X_project_id IS NULL
1922: OR X_task_id IS NULL ) THEN

Line 1938: pa_cc_utils.reset_curr_function ;

1934: IF ( dummy IS NOT NULL ) THEN
1935:
1936: X_outcome := 'PA_TR_RELATED_ITEM';
1937: X_status := 1;
1938: pa_cc_utils.reset_curr_function ;
1939: RETURN;
1940:
1941: END IF;
1942: /*

Line 1948: pa_cc_utils.reset_curr_function ;

1944: , X_expenditure_item_date ) ) THEN
1945:
1946: X_outcome := 'EXP_TYPE_INACTIVE';
1947: X_status := 1;
1948: pa_cc_utils.reset_curr_function ;
1949: RETURN;
1950:
1951: END IF;
1952: */

Line 1968: pa_cc_utils.reset_curr_function ;

1964: IF ( dummy = 0 ) THEN
1965:
1966: X_outcome := 'INVALID_EXP_TYPE';
1967: X_status := 1;
1968: pa_cc_utils.reset_curr_function ;
1969: RETURN;
1970:
1971: END IF;
1972:

Line 1976: pa_cc_utils.reset_curr_function ;

1972:
1973: IF ( X_etype_class NOT IN ('ST', 'OT' ) ) THEN
1974: X_outcome := 'INVALID_EXP_TYPE';
1975: X_status := 1;
1976: pa_cc_utils.reset_curr_function ;
1977: RETURN;
1978: END IF;
1979:
1980:

Line 2000: pa_cc_utils.reset_curr_function ;

1996: IF ( dummy = 0 ) THEN
1997:
1998: X_outcome := 'INVALID_ORGANIZATION';
1999: X_status := 1;
2000: pa_cc_utils.reset_curr_function ;
2001: RETURN;
2002:
2003: END IF;
2004:

Line 2021: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Before Call to PATC');

2017: -- for Bug # 519532.Since, Billable flag is an OUT parameter and was getting
2018: -- populated in get_status, it was seen that a null was getting passed. Hence
2019: -- added the call to get_status again.
2020: IF P_DEBUG_MODE THEN
2021: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Before Call to PATC');
2022: END IF;
2023:
2024: pa_transactions_pub.validate_transaction(
2025: X_project_id => X_dest_proj_id

Line 2080: pa_cc_utils.log_message('CreateRelatedItem: ' || 'After Call to PATC');

2076: , p_sys_link_function => X_etype_class);
2077: /* Added p_sys_link_function => X_etype_class for bug3557261 */
2078:
2079: IF P_DEBUG_MODE THEN
2080: pa_cc_utils.log_message('CreateRelatedItem: ' || 'After Call to PATC');
2081: END IF;
2082:
2083: /* Start of Bug 2648550 */
2084: l_assignment_id := PATC.G_OVERIDE_ASSIGNMENT_ID;

Line 2093: pa_cc_utils.reset_curr_function ;

2089: -- Since this is a batch program, we handle only errors,no warnings
2090:
2091: X_outcome := temp_outcome;
2092: X_status := 1;
2093: pa_cc_utils.reset_curr_function ;
2094: RETURN;
2095:
2096: END IF;
2097:

Line 2115: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Before Call to LoadEi');

2111: * Send the Recvr_Org_Id to LOADEI using the new API defined
2112: * in PA_UTILS2
2113: */
2114: IF P_DEBUG_MODE THEN
2115: pa_cc_utils.log_message('CreateRelatedItem: ' || 'Before Call to LoadEi');
2116: END IF;
2117:
2118: pa_transactions.LoadEi( X_expenditure_item_id => X_expenditure_item_id
2119: ,X_expenditure_id => X_expenditure_id

Line 2193: pa_cc_utils.log_message('CreateRelatedItem: ' || 'After call to LoadEi');

2189: , p_project_raw_cost => l_PROJECT_RAW_COST
2190: , p_project_burdened_cost => l_PROJECT_BURDENED_COST
2191: );
2192: IF P_DEBUG_MODE THEN
2193: pa_cc_utils.log_message('CreateRelatedItem: ' || 'After call to LoadEi');
2194: END IF;
2195:
2196: pa_transactions.InsItems( X_user => X_userid
2197: , X_login => 0

Line 2204: pa_cc_utils.log_message('CreateRelatedItem: ' || 'After call to InsItems');

2200: , Rows => 1
2201: , X_status => temp_status
2202: , X_gl_flag => 'N' );
2203: IF P_DEBUG_MODE THEN
2204: pa_cc_utils.log_message('CreateRelatedItem: ' || 'After call to InsItems');
2205: END IF;
2206:
2207: /*start of bug 5769510*/
2208: IF (l_gms_enabled = 'Y') THEN

Line 2253: pa_cc_utils.log_message('CreateRelatedItem: ' || 'End ');

2249:
2250: X_status := 0;
2251: X_outcome := NULL;
2252: IF P_DEBUG_MODE THEN
2253: pa_cc_utils.log_message('CreateRelatedItem: ' || 'End ');
2254: END IF;
2255: pa_cc_utils.reset_curr_function ;
2256:
2257: EXCEPTION

Line 2255: pa_cc_utils.reset_curr_function ;

2251: X_outcome := NULL;
2252: IF P_DEBUG_MODE THEN
2253: pa_cc_utils.log_message('CreateRelatedItem: ' || 'End ');
2254: END IF;
2255: pa_cc_utils.reset_curr_function ;
2256:
2257: EXCEPTION
2258: WHEN NO_DATA_FOUND THEN
2259: X_status := -1403;

Line 2283: pa_cc_utils.set_curr_function('UpdateRelatedItem');

2279:
2280: l_work_type_id NUMBER; /* bug2482593 */
2281:
2282: BEGIN
2283: pa_cc_utils.set_curr_function('UpdateRelatedItem');
2284: IF P_DEBUG_MODE THEN
2285: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'Start ');
2286: END IF;
2287:

Line 2285: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'Start ');

2281:
2282: BEGIN
2283: pa_cc_utils.set_curr_function('UpdateRelatedItem');
2284: IF P_DEBUG_MODE THEN
2285: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'Start ');
2286: END IF;
2287:
2288: /* changes for bug 2482593 start */
2289: if(X_work_type_name IS NOT NULL) then

Line 2300: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'Invalid Work Type Name');

2296: exception
2297: when no_data_found then
2298: X_status := 10;
2299: IF P_DEBUG_MODE THEN
2300: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'Invalid Work Type Name');
2301: END IF;
2302: pa_cc_utils.reset_curr_function ;
2303: return;
2304: end;

Line 2302: pa_cc_utils.reset_curr_function ;

2298: X_status := 10;
2299: IF P_DEBUG_MODE THEN
2300: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'Invalid Work Type Name');
2301: END IF;
2302: pa_cc_utils.reset_curr_function ;
2303: return;
2304: end;
2305:
2306: /* else

Line 2308: pa_cc_utils.log_message("Work Type ID defaults from source EI");

2304: end;
2305:
2306: /* else
2307: {
2308: pa_cc_utils.log_message("Work Type ID defaults from source EI");
2309: select work_type_id
2310: into l_work_type_id
2311: from pa_expenditure_items
2312: where expenditure_item_id = X_Expenditure_item_id;

Line 2342: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'End ');

2338: ei.expenditure_item_id = X_expenditure_item_id;
2339: */
2340: X_status := 0;
2341: IF P_DEBUG_MODE THEN
2342: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'End ');
2343: END IF;
2344: pa_cc_utils.reset_curr_function ;
2345:
2346: EXCEPTION

Line 2344: pa_cc_utils.reset_curr_function ;

2340: X_status := 0;
2341: IF P_DEBUG_MODE THEN
2342: pa_cc_utils.log_message('UpdateRelatedItem: ' || 'End ');
2343: END IF;
2344: pa_cc_utils.reset_curr_function ;
2345:
2346: EXCEPTION
2347: WHEN NO_DATA_FOUND THEN
2348: X_status := -1403;