DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_ADJUSTMENTS

Line 2742: -- PA adjustments for supplier invoice transactions

2738:
2739: -- ===================================================
2740: -- 5235363 R12.PJ:XB4:DEV:APL:EXP ITEM DATE VALIDATIONS FOR SUPPLIER COST.
2741: -- Following are not validated....
2742: -- PA adjustments for supplier invoice transactions
2743: -- Reversals
2744: -- Funds check adjustments
2745: -- Expenditure item adjustments
2746: -- Net ZERO Transactions for reversals

Line 4505: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';

4501: ( X_match_flag = 'N' and X_trx_src = 'ORACLE TIME AND LABOR' ) OR
4502: ( nvl(p_adj_exp_item_id,0) > 0 and nvl(X_module, 'EXTERNAL') = 'PAAPIMP') ) THEN
4503:
4504: IF PG_DEBUG = 'Y' THEN
4505: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';
4506: log_message('log_message: ' || pa_debug.G_err_Stage);
4507: END IF;
4508:
4509: /* REL12 AP Lines Uptake */

Line 4515: G_adj_item_id := pa_adjustments.VerifyOrigItem(

4511: nvl(X_module, 'EXTERNAL') = 'PAAPIMP' ) THEN
4512: G_adj_item_id := p_adj_exp_item_id ;
4513: ELSE
4514:
4515: G_adj_item_id := pa_adjustments.VerifyOrigItem(
4516: X_person_id => G_person_id
4517: , X_org_id => G_org_id
4518: , X_item_date => X_ei_date
4519: , X_task_id => G_task_id

Line 4545: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';

4541: ( X_module = 'PAXTRTRX' OR X_module = 'PAAPIMP') THEN
4542:
4543:
4544: IF PG_DEBUG = 'Y' THEN
4545: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
4546: log_message('log_message: ' || pa_debug.G_err_Stage);
4547: END IF;
4548: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
4549:

Line 4548: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;

4544: IF PG_DEBUG = 'Y' THEN
4545: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
4546: log_message('log_message: ' || pa_debug.G_err_Stage);
4547: END IF;
4548: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
4549:
4550: -- Commenting out the following procedure because verifyorigitem
4551: -- already checks for adjusted ei's that are not yet inserted into
4552: -- database table( EI Table). Bug 752915

Line 7351: pa_adjustments.ExpAdjItemTab := pa_utils.EmptyIdTab;

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;
7352:
7353: /***** Bug 4106188 CWK Changes *****/
7354: -- release_po_line_task_lock;
7355: -- init_po_amt_chk;

Line 7507: -- Reject the net zero reversals if pa adjustments have rejected

7503: END InitPLSQLTab;
7504:
7505: --
7506: -- Bug:5064930
7507: -- Reject the net zero reversals if pa adjustments have rejected
7508: -- logic description:
7509: -- supplier cost reversal transaction interface reverse the project
7510: -- adjustments corresponding to the source transactions.
7511: -- Supplier cost reversed transactions do not get interface if

Line 8678: -- Reject the net zero reversals if pa adjustments have rejected

8674: END IF ;
8675:
8676: --
8677: -- Bug:5064930
8678: -- Reject the net zero reversals if pa adjustments have rejected
8679: --
8680: x_status := get_parent_txn_status(x_status, j) ;
8681:
8682: -- R12 Check if we need date validations..

Line 12250: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';

12246: --
12247: IF ( ( X_qty < 0 and X_match_flag = 'N' ) OR
12248: ( X_match_flag = 'N' and X_trx_src = 'ORACLE TIME AND LABOR' ) ) THEN
12249: IF PG_DEBUG = 'Y' THEN
12250: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';
12251: log_message('log_message: ' || pa_debug.G_err_Stage);
12252: END IF;
12253: G_adj_item_id := pa_adjustments.VerifyOrigItem(
12254: X_person_id => G_person_id

Line 12253: G_adj_item_id := pa_adjustments.VerifyOrigItem(

12249: IF PG_DEBUG = 'Y' THEN
12250: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';
12251: log_message('log_message: ' || pa_debug.G_err_Stage);
12252: END IF;
12253: G_adj_item_id := pa_adjustments.VerifyOrigItem(
12254: X_person_id => G_person_id
12255: , X_org_id => G_org_id
12256: , X_item_date => X_ei_date
12257: , X_task_id => G_task_id

Line 12280: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';

12276:
12277: ELSIF ( G_adj_item_id IS NOT NULL AND X_module = 'PAXTRTRX' ) THEN
12278:
12279: IF PG_DEBUG = 'Y' THEN
12280: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
12281: log_message('log_message: ' || pa_debug.G_err_Stage);
12282: END IF;
12283: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
12284:

Line 12283: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;

12279: IF PG_DEBUG = 'Y' THEN
12280: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
12281: log_message('log_message: ' || pa_debug.G_err_Stage);
12282: END IF;
12283: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
12284:
12285: IF PG_DEBUG = 'Y' THEN
12286: pa_debug.G_err_stage := 'Locking adjusting item:'||to_char(G_adj_item_id);
12287: log_message('log_message: ' || pa_debug.G_err_Stage);