DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_ADJUSTMENTS

Line 2479: -- PA adjustments for supplier invoice transactions

2475:
2476: -- ===================================================
2477: -- 5235363 R12.PJ:XB4:DEV:APL:EXP ITEM DATE VALIDATIONS FOR SUPPLIER COST.
2478: -- Following are not validated....
2479: -- PA adjustments for supplier invoice transactions
2480: -- Reversals
2481: -- Funds check adjustments
2482: -- Expenditure item adjustments
2483: -- Net ZERO Transactions for reversals

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

4071: ( X_match_flag = 'N' and X_trx_src = 'ORACLE TIME AND LABOR' ) OR
4072: ( nvl(p_adj_exp_item_id,0) > 0 and nvl(X_module, 'EXTERNAL') = 'PAAPIMP') ) THEN
4073:
4074: IF PG_DEBUG = 'Y' THEN
4075: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';
4076: log_message('log_message: ' || pa_debug.G_err_Stage);
4077: END IF;
4078:
4079: /* REL12 AP Lines Uptake */

Line 4085: G_adj_item_id := pa_adjustments.VerifyOrigItem(

4081: nvl(X_module, 'EXTERNAL') = 'PAAPIMP' ) THEN
4082: G_adj_item_id := p_adj_exp_item_id ;
4083: ELSE
4084:
4085: G_adj_item_id := pa_adjustments.VerifyOrigItem(
4086: X_person_id => G_person_id
4087: , X_org_id => G_org_id
4088: , X_item_date => X_ei_date
4089: , X_task_id => G_task_id

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

4109: ( X_module = 'PAXTRTRX' OR X_module = 'PAAPIMP') THEN
4110:
4111:
4112: IF PG_DEBUG = 'Y' THEN
4113: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
4114: log_message('log_message: ' || pa_debug.G_err_Stage);
4115: END IF;
4116: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
4117:

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

4112: IF PG_DEBUG = 'Y' THEN
4113: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
4114: log_message('log_message: ' || pa_debug.G_err_Stage);
4115: END IF;
4116: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
4117:
4118: -- Commenting out the following procedure because verifyorigitem
4119: -- already checks for adjusted ei's that are not yet inserted into
4120: -- database table( EI Table). Bug 752915

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

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;
6759:
6760: /***** Bug 4106188 CWK Changes *****/
6761: -- release_po_line_task_lock;
6762: -- init_po_amt_chk;

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

6900: END InitPLSQLTab;
6901:
6902: --
6903: -- Bug:5064930
6904: -- Reject the net zero reversals if pa adjustments have rejected
6905: -- logic description:
6906: -- supplier cost reversal transaction interface reverse the project
6907: -- adjustments corresponding to the source transactions.
6908: -- Supplier cost reversed transactions do not get interface if

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

7991: END IF ;
7992:
7993: --
7994: -- Bug:5064930
7995: -- Reject the net zero reversals if pa adjustments have rejected
7996: --
7997: x_status := get_parent_txn_status(x_status, j) ;
7998:
7999: -- R12 Check if we need date validations..

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

11363: --
11364: IF ( ( X_qty < 0 and X_match_flag = 'N' ) OR
11365: ( X_match_flag = 'N' and X_trx_src = 'ORACLE TIME AND LABOR' ) ) THEN
11366: IF PG_DEBUG = 'Y' THEN
11367: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';
11368: log_message('log_message: ' || pa_debug.G_err_Stage);
11369: END IF;
11370: G_adj_item_id := pa_adjustments.VerifyOrigItem(
11371: X_person_id => G_person_id

Line 11370: G_adj_item_id := pa_adjustments.VerifyOrigItem(

11366: IF PG_DEBUG = 'Y' THEN
11367: pa_debug.G_err_stage := 'Calling pa_adjustments.VerifyOrigItem';
11368: log_message('log_message: ' || pa_debug.G_err_Stage);
11369: END IF;
11370: G_adj_item_id := pa_adjustments.VerifyOrigItem(
11371: X_person_id => G_person_id
11372: , X_org_id => G_org_id
11373: , X_item_date => X_ei_date
11374: , X_task_id => G_task_id

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

11391:
11392: ELSIF ( G_adj_item_id IS NOT NULL AND X_module = 'PAXTRTRX' ) THEN
11393:
11394: IF PG_DEBUG = 'Y' THEN
11395: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
11396: log_message('log_message: ' || pa_debug.G_err_Stage);
11397: END IF;
11398: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
11399:

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

11394: IF PG_DEBUG = 'Y' THEN
11395: pa_debug.G_err_stage := 'Calling pa_adjustments.ExpAdjItemTab';
11396: log_message('log_message: ' || pa_debug.G_err_Stage);
11397: END IF;
11398: pa_adjustments.ExpAdjItemTab(G_adj_item_id) := G_adj_item_id;
11399:
11400: IF PG_DEBUG = 'Y' THEN
11401: pa_debug.G_err_stage := 'Locking adjusting item:'||to_char(G_adj_item_id);
11402: log_message('log_message: ' || pa_debug.G_err_Stage);