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_TRX_IMPORT dependencies on PA_TRANSACTIONS

Line 1020: IF ( pa_transactions.TrxRefTab(j) = X_trx_ref ) THEN

1016:
1017: ELSIF ( i > 0 ) THEN
1018:
1019: FOR j IN 1..i LOOP
1020: IF ( pa_transactions.TrxRefTab(j) = X_trx_ref ) THEN
1021: X_status := 'DUPLICATE_ITEM';
1022: pa_cc_utils.reset_curr_function;
1023: RETURN;
1024: END IF;

Line 1044: IF ( pa_transactions.AdjEiTab(j) = X_adj_item_id) THEN

1040: pa_cc_utils.set_curr_function('CheckDupAdjItem');
1041: IF ( i > 0 ) THEN
1042:
1043: FOR j IN 1..i LOOP
1044: IF ( pa_transactions.AdjEiTab(j) = X_adj_item_id) THEN
1045: X_status := 'DUPLICATE_ADJUST_ITEM';
1046: pa_cc_utils.reset_curr_function;
1047: RETURN;
1048: END IF;

Line 5098: -- Calls pa_transactions_pub.validate_dff

5094: -- Verify that transaction does not violate any transaction controls,
5095: -- including transaction control extensions
5096: --
5097: -- DFF Upgrade:
5098: -- Calls pa_transactions_pub.validate_dff
5099: IF PG_DEBUG = 'Y' THEN
5100: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';
5101: log_message('log_message: ' || pa_debug.G_err_Stage);
5102: END IF;

Line 5100: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';

5096: --
5097: -- DFF Upgrade:
5098: -- Calls pa_transactions_pub.validate_dff
5099: IF PG_DEBUG = 'Y' THEN
5100: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';
5101: log_message('log_message: ' || pa_debug.G_err_Stage);
5102: END IF;
5103:
5104: pa_transactions_pub.validate_dff(

Line 5104: pa_transactions_pub.validate_dff(

5100: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';
5101: log_message('log_message: ' || pa_debug.G_err_Stage);
5102: END IF;
5103:
5104: pa_transactions_pub.validate_dff(
5105: p_dff_name => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
5106: p_attribute_category => X_att_cat,
5107: p_attribute1 => X_att1,
5108: p_attribute2 => X_att2,

Line 5140: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_transaction';

5136: RETURN;
5137: END IF;
5138:
5139: IF PG_DEBUG = 'Y' THEN
5140: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_transaction';
5141: log_message('log_message: ' || pa_debug.G_err_Stage);
5142: END IF;
5143:
5144: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833

Line 5146: pa_transactions_pub.validate_transaction(

5142: END IF;
5143:
5144: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833
5145:
5146: pa_transactions_pub.validate_transaction(
5147: X_project_id => G_project_id
5148: , X_task_id => G_task_id
5149: , X_ei_date => X_ei_date
5150: , X_expenditure_type => X_etype

Line 5214: pa_debug.G_err_stage := 'After pa_transactions_pub.validate_transaction';

5210:
5211: END IF;
5212:
5213: IF PG_DEBUG = 'Y' THEN
5214: pa_debug.G_err_stage := 'After pa_transactions_pub.validate_transaction';
5215: log_message('log_message: ' || pa_debug.G_err_Stage);
5216: END IF;
5217:
5218: -- IF G_skip_tc_flag <> 'Y' THEN /* commented for Bug # 2108456 */

Line 6463: -- pa_transactions.insertexp

6459: pa_cc_utils.reset_curr_function;
6460: END loadExpCompareVars;
6461:
6462: -- Bug 2048868 : Added 5 parameters to pass currency attributes to
6463: -- pa_transactions.insertexp
6464:
6465: PROCEDURE newExpend ( group_name IN VARCHAR2
6466: , ending_date IN DATE
6467: , record_count IN NUMBER

Line 6512: pa_debug.G_err_Stage := 'Calling pa_transactions.InsertExpGroupNew';

6508:
6509: IF X_transaction_source NOT IN ('PTE TIME', 'PTE EXPENSE') THEN
6510:
6511: IF PG_DEBUG = 'Y' THEN
6512: pa_debug.G_err_Stage := 'Calling pa_transactions.InsertExpGroupNew';
6513: log_message('log_message: ' || pa_debug.G_err_Stage);
6514: log_message('log_message: ' || 'Group Name = ' || group_name || ' Sys Link = ' || current_system_linkage);
6515: END IF;
6516:

Line 6519: pa_transactions.InsertExpGroupNew(

6515: END IF;
6516:
6517: IF (group_name <> nvl(G_group_name,'X')) THEN
6518:
6519: pa_transactions.InsertExpGroupNew(
6520: group_name
6521: , 'RELEASED'
6522: , ending_date
6523: , current_system_linkage

Line 6556: pa_debug.G_err_Stage := 'Calling pa_transactions.InsertExp';

6552: WHERE expenditure_id = G_expenditure_id;
6553:
6554: ELSE
6555: IF PG_DEBUG = 'Y' THEN
6556: pa_debug.G_err_Stage := 'Calling pa_transactions.InsertExp';
6557: log_message('log_message: ' || pa_debug.G_err_Stage);
6558: END IF;
6559: -- Trx_import enhancement
6560: -- Bug 2048868 : Added 5 parameters to pass currency attributes to

Line 6561: -- pa_transactions.insertexp

6557: log_message('log_message: ' || pa_debug.G_err_Stage);
6558: END IF;
6559: -- Trx_import enhancement
6560: -- Bug 2048868 : Added 5 parameters to pass currency attributes to
6561: -- pa_transactions.insertexp
6562: -- If system_linkage = ER
6563:
6564:
6565:

Line 6583: pa_transactions.InsertExp(

6579: else
6580: l_acct_rate_date := p_acct_rate_date;
6581: end if;
6582:
6583: pa_transactions.InsertExp(
6584: X_expenditure_id => G_expenditure_id,
6585: X_expend_status => 'APPROVED',
6586: X_expend_ending => ending_date,
6587: X_expend_class => G_eclass,

Line 6610: pa_transactions.InsertExp(

6606: p_org_id => g_moac_org_id); /*cwk */
6607:
6608: ELSE
6609:
6610: pa_transactions.InsertExp(
6611: X_expenditure_id => G_expenditure_id,
6612: X_expend_status => 'APPROVED',
6613: X_expend_ending => ending_date,
6614: X_expend_class => G_eclass,

Line 6636: pa_debug.G_err_Stage := 'Calling pa_transactions.InsItems';

6632:
6633: END IF;
6634:
6635: IF PG_DEBUG = 'Y' THEN
6636: pa_debug.G_err_Stage := 'Calling pa_transactions.InsItems';
6637: log_message('log_message: ' || pa_debug.G_err_Stage);
6638: END IF;
6639:
6640: select decode(G_gl_accted_flag,'N','N',decode(G_gl_posted_flag,'Y','Y','P')) into l_gl_accted_flag from dual;

Line 6642: pa_transactions.InsItems(

6638: END IF;
6639:
6640: select decode(G_gl_accted_flag,'N','N',decode(G_gl_posted_flag,'Y','Y','P')) into l_gl_accted_flag from dual;
6641:
6642: pa_transactions.InsItems(
6643: X_userid
6644: , 0
6645: , 'PAXTRTRX'
6646: , 'TRX_IMPORT'

Line 6656: -- pa_transactions.InsItems.

6652: -- OGM_0.0 - Interface for creating new ADLS for each expenditure Item
6653: -- created. This will create award distribution lines only when OGM is
6654: -- installed for the ORG in process.
6655: -- The folowing procedure returns doing nothing if status is in ERROR for
6656: -- pa_transactions.InsItems.
6657: -- ------------------------------------------------------------------------
6658: IF PG_DEBUG = 'Y' THEN
6659: log_message('log_message: ' || '1760:Call Vertical APPS interface for i>=500');
6660: END IF;

Line 6751: pa_debug.G_err_stage := 'Calling pa_transactions.FlushEiTabs';

6747: END IF;
6748: END IF;
6749:
6750: IF PG_DEBUG = 'Y' THEN
6751: pa_debug.G_err_stage := 'Calling pa_transactions.FlushEiTabs';
6752: log_message('log_message: ' || pa_debug.G_err_Stage);
6753: END IF;
6754: pa_transactions.FlushEiTabs;
6755:

Line 6754: pa_transactions.FlushEiTabs;

6750: IF PG_DEBUG = 'Y' THEN
6751: pa_debug.G_err_stage := 'Calling pa_transactions.FlushEiTabs';
6752: log_message('log_message: ' || pa_debug.G_err_Stage);
6753: END IF;
6754: pa_transactions.FlushEiTabs;
6755:
6756: -- Bug 752915, added the following to flush the adjustments ei pl/sql table
6757: --
6758: pa_adjustments.ExpAdjItemTab := pa_utils.EmptyIdTab;

Line 8417: -- PA_transactions package that this is a cash based accounting when invoice distributions

8413: -- R12.PJ:XB7:QA:APL:UPG:ADJUSTMENT REVERSAL NOT GETTING ACCOUNTED IN CASH
8414: -- Resolution :
8415: -- We need to mark such expenditure items corresponding to invoice distributions
8416: -- as historical. The '-1' value in the l_doc_payment_id would indicate in
8417: -- PA_transactions package that this is a cash based accounting when invoice distributions
8418: -- is getting interfaced instead of payment. The value would be flipped back to null
8419: -- in the pa transactions InsItems api before creating the exp items.
8420: l_doc_payment_id := -1 ;
8421: END IF ;

Line 8419: -- in the pa transactions InsItems api before creating the exp items.

8415: -- We need to mark such expenditure items corresponding to invoice distributions
8416: -- as historical. The '-1' value in the l_doc_payment_id would indicate in
8417: -- PA_transactions package that this is a cash based accounting when invoice distributions
8418: -- is getting interfaced instead of payment. The value would be flipped back to null
8419: -- in the pa transactions InsItems api before creating the exp items.
8420: l_doc_payment_id := -1 ;
8421: END IF ;
8422:
8423: -- l_SysRef1Tab records the payment hist dist ID when needed to go to system_reference5

Line 8547: -- billable flag derived from pa_transactions_pub.validate_transaction

8543:
8544: -- SSt changes
8545: -- For contract and capital projects, if the billable flag
8546: -- is populated in the interface table, then override the
8547: -- billable flag derived from pa_transactions_pub.validate_transaction
8548: -- with the value in the billable flag column
8549:
8550: IF PG_DEBUG = 'Y' THEN
8551: log_message('log_message: ' || 'Intial Billable Flag = ' || X_billable_flag);

Line 8687: pa_transactions.LoadEi( X_expenditure_item_id => X_ei_id

8683: G_nlro_id := Null;
8684: END IF;/*Bug 4503768*/
8685: -- Bug 4604493, 4503768 ends
8686:
8687: pa_transactions.LoadEi( X_expenditure_item_id => X_ei_id
8688: --PA-K Changes: TrxRec.expenditure_item_id
8689: ,X_expenditure_id => G_expenditure_id
8690: ,X_expenditure_item_date => l_EiDateTab(j)
8691: ,X_project_id => G_project_id

Line 8814: pa_transactions.LoadEi(

8810:
8811: -- increment the counter
8812: i := i + 1;
8813:
8814: pa_transactions.LoadEi(
8815: X_expenditure_item_id => pa_utils.GetNextEiId
8816: ,X_expenditure_id => G_expenditure_id
8817: ,X_expenditure_item_date => l_EiDateTab(j)
8818: ,X_project_id => G_project_id