DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_ON_FLY_TRX_UPGRADE_PKG

Line 20: p_upg_trx_info_rec IN ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type,

16: --
17: -------------------------------------------------------------------------------
18:
19: PROCEDURE upgrade_trx_on_fly_po(
20: p_upg_trx_info_rec IN ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type,
21: x_return_status OUT NOCOPY VARCHAR2
22: ) AS
23:
24: l_org_id NUMBER;

Line 47: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

43: FND_PROFILE.GET('ORG_ID',l_org_id);
44: IF l_org_id is NULL THEN
45: IF (g_level_unexpected >= g_current_runtime_level ) THEN
46: FND_LOG.STRING(g_level_unexpected,
47: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
48: 'Current envionment is a Single Org environment,'||
49: ' but profile ORG_ID is not set up');
50: END IF;
51: END IF;

Line 95: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

91: x_return_status => x_return_status);
92:
93: IF (g_level_statement >= g_current_runtime_level ) THEN
94: FND_LOG.STRING(g_level_statement,
95: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
96: 'Inserting data into zx_lines_det_factors');
97: END IF;
98:
99: -- Insert data into zx_lines_det_factors

Line 526: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

522: -- COMMIT;
523:
524: IF (g_level_statement >= g_current_runtime_level ) THEN
525: FND_LOG.STRING(g_level_statement,
526: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
527: 'Inserting data into zx_lines: tax code');
528: END IF;
529:
530: -- Insert data into zx_lines

Line 1228: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

1224: END IF;
1225:
1226: IF (g_level_statement >= g_current_runtime_level ) THEN
1227: FND_LOG.STRING(g_level_statement,
1228: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1229: 'Inserting data into zx_lines');
1230: END IF;
1231:
1232: -- Insert data into zx_lines

Line 1949: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

1945: -- COMMIT;
1946:
1947: IF (g_level_statement >= g_current_runtime_level ) THEN
1948: FND_LOG.STRING(g_level_statement,
1949: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1950: 'Inserting data into zx_rec_nrec_dist');
1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist

Line 2862: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

2858: -- COMMIT;
2859:
2860: IF (g_level_statement >= g_current_runtime_level ) THEN
2861: FND_LOG.STRING(g_level_statement,
2862: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2863: 'Inserting data into zx_lines (Tax Code)');
2864: END IF;
2865:
2866: -- Insert data into zx_lines

Line 3577: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

3573: END IF;
3574:
3575: IF (g_level_statement >= g_current_runtime_level ) THEN
3576: FND_LOG.STRING(g_level_statement,
3577: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3578: 'Inserting data into zx_lines(Tax Group)');
3579: END IF;
3580:
3581: -- Insert data into zx_lines

Line 4311: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

4307: -- COMMIT;
4308:
4309: IF (g_level_statement >= g_current_runtime_level ) THEN
4310: FND_LOG.STRING(g_level_statement,
4311: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4312: 'Inserting data into zx_rec_nrec_dist');
4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist

Line 4842: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

4838: FND_PROFILE.GET('ORG_ID',l_org_id);
4839: IF l_org_id is NULL THEN
4840: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4841: FND_LOG.STRING(g_level_unexpected,
4842: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4843: 'Current envionment is a Single Org environment,'||
4844: ' but profile ORG_ID is not set up');
4845: END IF;
4846: END IF;

Line 4855: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

4851: ZX_PO_REC_PKG.get_rec_info(x_return_status => x_return_status);
4852:
4853: IF (g_level_statement >= g_current_runtime_level ) THEN
4854: FND_LOG.STRING(g_level_statement,
4855: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --

Line 5283: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

5279: -- COMMIT;
5280:
5281: IF (g_level_statement >= g_current_runtime_level ) THEN
5282: FND_LOG.STRING(g_level_statement,
5283: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5284: 'Inserting data into zx_lines(Tax Code)');
5285: END IF;
5286:
5287: -- Insert data into zx_lines

Line 5984: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

5980: END IF;
5981:
5982: IF (g_level_statement >= g_current_runtime_level ) THEN
5983: FND_LOG.STRING(g_level_statement,
5984: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5985: 'Inserting data into zx_lines(Tax Group)');
5986: END IF;
5987:
5988: -- Insert data into zx_lines

Line 6702: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

6698: -- COMMIT;
6699:
6700: IF (g_level_statement >= g_current_runtime_level ) THEN
6701: FND_LOG.STRING(g_level_statement,
6702: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6703: 'Inserting data into zx_rec_nrec_dist');
6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist

Line 7604: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

7600: -- COMMIT;
7601:
7602: IF (g_level_statement >= g_current_runtime_level ) THEN
7603: FND_LOG.STRING(g_level_statement,
7604: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7605: 'Inserting data into zx_lines(Tax Code)');
7606: END IF;
7607:
7608: -- Insert data into zx_lines

Line 8314: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

8310: END IF;
8311:
8312: IF (g_level_statement >= g_current_runtime_level ) THEN
8313: FND_LOG.STRING(g_level_statement,
8314: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8315: 'Inserting data into zx_lines(Tax Group)');
8316: END IF;
8317:
8318: -- Insert data into zx_lines

Line 9042: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',

9038: -- COMMIT;
9039:
9040: IF (g_level_statement >= g_current_runtime_level ) THEN
9041: FND_LOG.STRING(g_level_statement,
9042: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
9043: 'Inserting data into zx_rec_nrec_dist');
9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist