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 1096: IF ( pa_transactions.TrxRefTab(j) = X_trx_ref ) THEN

1092:
1093: ELSIF ( i > 0 ) THEN
1094:
1095: FOR j IN 1..i LOOP
1096: IF ( pa_transactions.TrxRefTab(j) = X_trx_ref ) THEN
1097: X_status := 'DUPLICATE_ITEM';
1098: pa_cc_utils.reset_curr_function;
1099: RETURN;
1100: END IF;

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

1122:
1123: IF ( i > 0 ) THEN
1124:
1125: FOR j IN 1..i LOOP
1126: IF ( pa_transactions.AdjEiTab(j) = X_adj_item_id) THEN
1127: X_status := 'DUPLICATE_ADJUST_ITEM';
1128: pa_cc_utils.reset_curr_function;
1129: RETURN;
1130: END IF;

Line 5534: -- Calls pa_transactions_pub.validate_dff

5530: -- Verify that transaction does not violate any transaction controls,
5531: -- including transaction control extensions
5532: --
5533: -- DFF Upgrade:
5534: -- Calls pa_transactions_pub.validate_dff
5535: IF PG_DEBUG = 'Y' THEN
5536: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';
5537: log_message('log_message: ' || pa_debug.G_err_Stage);
5538: END IF;

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

5532: --
5533: -- DFF Upgrade:
5534: -- Calls pa_transactions_pub.validate_dff
5535: IF PG_DEBUG = 'Y' THEN
5536: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';
5537: log_message('log_message: ' || pa_debug.G_err_Stage);
5538: END IF;
5539:
5540: pa_transactions_pub.validate_dff(

Line 5540: pa_transactions_pub.validate_dff(

5536: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_dff';
5537: log_message('log_message: ' || pa_debug.G_err_Stage);
5538: END IF;
5539:
5540: pa_transactions_pub.validate_dff(
5541: p_dff_name => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
5542: p_attribute_category => X_att_cat,
5543: p_attribute1 => X_att1,
5544: p_attribute2 => X_att2,

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

5572: RETURN;
5573: END IF;
5574:
5575: IF PG_DEBUG = 'Y' THEN
5576: pa_debug.G_err_stage := 'Calling pa_transactions_pub.validate_transaction';
5577: log_message('log_message: ' || pa_debug.G_err_Stage);
5578: END IF;
5579:
5580: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833

Line 5582: pa_transactions_pub.validate_transaction(

5578: END IF;
5579:
5580: If PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then -- Added for BUG6931833
5581:
5582: pa_transactions_pub.validate_transaction(
5583: X_project_id => G_project_id
5584: , X_task_id => G_task_id
5585: , X_ei_date => X_ei_date
5586: , X_expenditure_type => X_etype

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

5652:
5653: END IF;
5654:
5655: IF PG_DEBUG = 'Y' THEN
5656: pa_debug.G_err_stage := 'After pa_transactions_pub.validate_transaction';
5657: log_message('log_message: ' || pa_debug.G_err_Stage);
5658: END IF;
5659:
5660: -- IF G_skip_tc_flag <> 'Y' THEN /* commented for Bug # 2108456 */

Line 7026: -- pa_transactions.insertexp

7022: pa_cc_utils.reset_curr_function;
7023: END loadExpCompareVars;
7024:
7025: -- Bug 2048868 : Added 5 parameters to pass currency attributes to
7026: -- pa_transactions.insertexp
7027:
7028: PROCEDURE newExpend ( group_name IN VARCHAR2
7029: , ending_date IN DATE
7030: , record_count IN NUMBER

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

7072:
7073: IF X_transaction_source NOT IN ('PTE TIME', 'PTE EXPENSE') THEN
7074:
7075: IF PG_DEBUG = 'Y' THEN
7076: pa_debug.G_err_Stage := 'Calling pa_transactions.InsertExpGroupNew';
7077: log_message('log_message: ' || pa_debug.G_err_Stage);
7078: log_message('log_message: ' || 'Group Name = ' || group_name || ' Sys Link = ' || current_system_linkage);
7079: END IF;
7080:

Line 7083: pa_transactions.InsertExpGroupNew(

7079: END IF;
7080:
7081: IF (group_name <> nvl(G_group_name,'X')) THEN
7082:
7083: pa_transactions.InsertExpGroupNew(
7084: group_name
7085: , 'RELEASED'
7086: , ending_date
7087: , current_system_linkage

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

7116: WHERE expenditure_id = G_expenditure_id;
7117:
7118: ELSE
7119: IF PG_DEBUG = 'Y' THEN
7120: pa_debug.G_err_Stage := 'Calling pa_transactions.InsertExp';
7121: log_message('log_message: ' || pa_debug.G_err_Stage);
7122: END IF;
7123: -- Trx_import enhancement
7124: -- Bug 2048868 : Added 5 parameters to pass currency attributes to

Line 7125: -- pa_transactions.insertexp

7121: log_message('log_message: ' || pa_debug.G_err_Stage);
7122: END IF;
7123: -- Trx_import enhancement
7124: -- Bug 2048868 : Added 5 parameters to pass currency attributes to
7125: -- pa_transactions.insertexp
7126: -- If system_linkage = ER
7127:
7128:
7129:

Line 7157: pa_transactions.InsertExp(

7153: l_person_type := p_person_type;
7154: end if;
7155: /* Added for bug 13554435 */
7156:
7157: pa_transactions.InsertExp(
7158: X_expenditure_id => G_expenditure_id,
7159: X_expend_status => 'APPROVED',
7160: X_expend_ending => ending_date,
7161: X_expend_class => G_eclass,

Line 7203: pa_transactions.InsertExp(

7199: l_person_type := p_person_type;
7200: end if;
7201: /* Added for bug 13554435 */
7202:
7203: pa_transactions.InsertExp(
7204: X_expenditure_id => G_expenditure_id,
7205: X_expend_status => 'APPROVED',
7206: X_expend_ending => ending_date,
7207: X_expend_class => G_eclass,

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

7225:
7226: END IF;
7227:
7228: IF PG_DEBUG = 'Y' THEN
7229: pa_debug.G_err_Stage := 'Calling pa_transactions.InsItems';
7230: log_message('log_message: ' || pa_debug.G_err_Stage);
7231: END IF;
7232:
7233: select decode(G_gl_accted_flag,'N','N',decode(G_gl_posted_flag,'Y','Y','P')) into l_gl_accted_flag from dual;

Line 7235: pa_transactions.InsItems(

7231: END IF;
7232:
7233: select decode(G_gl_accted_flag,'N','N',decode(G_gl_posted_flag,'Y','Y','P')) into l_gl_accted_flag from dual;
7234:
7235: pa_transactions.InsItems(
7236: X_userid
7237: , 0
7238: , 'PAXTRTRX'
7239: , 'TRX_IMPORT'

Line 7249: -- pa_transactions.InsItems.

7245: -- OGM_0.0 - Interface for creating new ADLS for each expenditure Item
7246: -- created. This will create award distribution lines only when OGM is
7247: -- installed for the ORG in process.
7248: -- The folowing procedure returns doing nothing if status is in ERROR for
7249: -- pa_transactions.InsItems.
7250: -- ------------------------------------------------------------------------
7251: IF PG_DEBUG = 'Y' THEN
7252: log_message('log_message: ' || '1760:Call Vertical APPS interface for i>=500');
7253: END IF;

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

7340: END IF;
7341: END IF;
7342:
7343: IF PG_DEBUG = 'Y' THEN
7344: pa_debug.G_err_stage := 'Calling pa_transactions.FlushEiTabs';
7345: log_message('log_message: ' || pa_debug.G_err_Stage);
7346: END IF;
7347: pa_transactions.FlushEiTabs;
7348:

Line 7347: pa_transactions.FlushEiTabs;

7343: IF PG_DEBUG = 'Y' THEN
7344: pa_debug.G_err_stage := 'Calling pa_transactions.FlushEiTabs';
7345: log_message('log_message: ' || pa_debug.G_err_Stage);
7346: END IF;
7347: pa_transactions.FlushEiTabs;
7348:
7349: -- Bug 752915, added the following to flush the adjustments ei pl/sql table
7350: --
7351: pa_adjustments.ExpAdjItemTab := pa_utils.EmptyIdTab;

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

9144: -- R12.PJ:XB7:QA:APL:UPG:ADJUSTMENT REVERSAL NOT GETTING ACCOUNTED IN CASH
9145: -- Resolution :
9146: -- We need to mark such expenditure items corresponding to invoice distributions
9147: -- as historical. The '-1' value in the l_doc_payment_id would indicate in
9148: -- PA_transactions package that this is a cash based accounting when invoice distributions
9149: -- is getting interfaced instead of payment. The value would be flipped back to null
9150: -- in the pa transactions InsItems api before creating the exp items.
9151: l_doc_payment_id := -1 ;
9152: END IF ;

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

9146: -- We need to mark such expenditure items corresponding to invoice distributions
9147: -- as historical. The '-1' value in the l_doc_payment_id would indicate in
9148: -- PA_transactions package that this is a cash based accounting when invoice distributions
9149: -- is getting interfaced instead of payment. The value would be flipped back to null
9150: -- in the pa transactions InsItems api before creating the exp items.
9151: l_doc_payment_id := -1 ;
9152: END IF ;
9153:
9154: -- l_SysRef1Tab records the payment hist dist ID when needed to go to system_reference5

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

9290:
9291: -- SSt changes
9292: -- For contract and capital projects, if the billable flag
9293: -- is populated in the interface table, then override the
9294: -- billable flag derived from pa_transactions_pub.validate_transaction
9295: -- with the value in the billable flag column
9296:
9297: IF PG_DEBUG = 'Y' THEN
9298: log_message('log_message: ' || 'Intial Billable Flag = ' || X_billable_flag);

Line 9467: pa_transactions.LoadEi( X_expenditure_item_id => X_ei_id

9463: END IF;
9464:
9465: /* End changes for bug#12646547 */
9466:
9467: pa_transactions.LoadEi( X_expenditure_item_id => X_ei_id
9468: --PA-K Changes: TrxRec.expenditure_item_id
9469: ,X_expenditure_id => G_expenditure_id
9470: ,X_expenditure_item_date => l_EiDateTab(j)
9471: ,X_project_id => G_project_id

Line 9598: pa_transactions.LoadEi(

9594:
9595: -- increment the counter
9596: i := i + 1;
9597:
9598: pa_transactions.LoadEi(
9599: X_expenditure_item_id => pa_utils.GetNextEiId
9600: ,X_expenditure_id => G_expenditure_id
9601: ,X_expenditure_item_date => l_EiDateTab(j)
9602: ,X_project_id => G_project_id