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 46: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',

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

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

56: x_return_status => x_return_status);
57:
58: IF (g_level_statement >= g_current_runtime_level ) THEN
59: FND_LOG.STRING(g_level_statement,
60: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
61: 'Inserting data into zx_lines_det_factors');
62: END IF;
63:
64: -- Insert data into zx_lines_det_factors

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

488: -- COMMIT;
489:
490: IF (g_level_statement >= g_current_runtime_level ) THEN
491: FND_LOG.STRING(g_level_statement,
492: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
493: 'Inserting data into zx_lines: tax code');
494: END IF;
495:
496: -- Insert data into zx_lines

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

1194: END IF;
1195:
1196: IF (g_level_statement >= g_current_runtime_level ) THEN
1197: FND_LOG.STRING(g_level_statement,
1198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1199: 'Inserting data into zx_lines');
1200: END IF;
1201:
1202: -- Insert data into zx_lines

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

1915: -- COMMIT;
1916:
1917: IF (g_level_statement >= g_current_runtime_level ) THEN
1918: FND_LOG.STRING(g_level_statement,
1919: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1920: 'Inserting data into zx_rec_nrec_dist');
1921: END IF;
1922:
1923: -- Insert data into zx_rec_nrec_dist

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

2797: -- COMMIT;
2798:
2799: IF (g_level_statement >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_statement,
2801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2802: 'Inserting data into zx_lines (Tax Code)');
2803: END IF;
2804:
2805: -- Insert data into zx_lines

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

3515: END IF;
3516:
3517: IF (g_level_statement >= g_current_runtime_level ) THEN
3518: FND_LOG.STRING(g_level_statement,
3519: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3520: 'Inserting data into zx_lines(Tax Group)');
3521: END IF;
3522:
3523: -- Insert data into zx_lines

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

4249: -- COMMIT;
4250:
4251: IF (g_level_statement >= g_current_runtime_level ) THEN
4252: FND_LOG.STRING(g_level_statement,
4253: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4254: 'Inserting data into zx_rec_nrec_dist');
4255: END IF;
4256:
4257: -- Insert data into zx_rec_nrec_dist

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

4748: FND_PROFILE.GET('ORG_ID',l_org_id);
4749: IF l_org_id is NULL THEN
4750: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4751: FND_LOG.STRING(g_level_unexpected,
4752: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4753: 'Current envionment is a Single Org environment,'||
4754: ' but profile ORG_ID is not set up');
4755: END IF;
4756: END IF;

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

4761: ZX_PO_REC_PKG.get_rec_info(x_return_status => x_return_status);
4762:
4763: IF (g_level_statement >= g_current_runtime_level ) THEN
4764: FND_LOG.STRING(g_level_statement,
4765: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --

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

5190: -- COMMIT;
5191:
5192: IF (g_level_statement >= g_current_runtime_level ) THEN
5193: FND_LOG.STRING(g_level_statement,
5194: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5195: 'Inserting data into zx_lines(Tax Code)');
5196: END IF;
5197:
5198: -- Insert data into zx_lines

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

5894: END IF;
5895:
5896: IF (g_level_statement >= g_current_runtime_level ) THEN
5897: FND_LOG.STRING(g_level_statement,
5898: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5899: 'Inserting data into zx_lines(Tax Group)');
5900: END IF;
5901:
5902: -- Insert data into zx_lines

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

6612: -- COMMIT;
6613:
6614: IF (g_level_statement >= g_current_runtime_level ) THEN
6615: FND_LOG.STRING(g_level_statement,
6616: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6617: 'Inserting data into zx_rec_nrec_dist');
6618: END IF;
6619:
6620: -- Insert data into zx_rec_nrec_dist

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

7485: -- COMMIT;
7486:
7487: IF (g_level_statement >= g_current_runtime_level ) THEN
7488: FND_LOG.STRING(g_level_statement,
7489: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7490: 'Inserting data into zx_lines(Tax Code)');
7491: END IF;
7492:
7493: -- Insert data into zx_lines

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

8198: END IF;
8199:
8200: IF (g_level_statement >= g_current_runtime_level ) THEN
8201: FND_LOG.STRING(g_level_statement,
8202: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8203: 'Inserting data into zx_lines(Tax Group)');
8204: END IF;
8205:
8206: -- Insert data into zx_lines

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

8926: -- COMMIT;
8927:
8928: IF (g_level_statement >= g_current_runtime_level ) THEN
8929: FND_LOG.STRING(g_level_statement,
8930: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8931: 'Inserting data into zx_rec_nrec_dist');
8932: END IF;
8933:
8934: -- Insert data into zx_rec_nrec_dist