DBA Data[Home] [Help]

APPS.PO_HR_LOCATION dependencies on PO_HR_LOCATION

Line 1: PACKAGE BODY PO_HR_LOCATION AS

1: PACKAGE BODY PO_HR_LOCATION AS
2: /* $Header: POXPRPOB.pls 120.3.12000000.5 2007/04/27 11:22:31 cvardia ship $*/
3:
4: g_address_details PO_HR_LOCATION.address; -- Its a PL/SQL table of po_address_details_gt rowtype
5:

Line 4: g_address_details PO_HR_LOCATION.address; -- Its a PL/SQL table of po_address_details_gt rowtype

1: PACKAGE BODY PO_HR_LOCATION AS
2: /* $Header: POXPRPOB.pls 120.3.12000000.5 2007/04/27 11:22:31 cvardia ship $*/
3:
4: g_address_details PO_HR_LOCATION.address; -- Its a PL/SQL table of po_address_details_gt rowtype
5:
6: g_addr_prompt_query PO_HR_LOCATION.addr_prompt_query; --PL/SQL table for storing style code, query and prompt list.
7:
8: -- Debugging booleans used to bypass logging when turned off

Line 6: g_addr_prompt_query PO_HR_LOCATION.addr_prompt_query; --PL/SQL table for storing style code, query and prompt list.

2: /* $Header: POXPRPOB.pls 120.3.12000000.5 2007/04/27 11:22:31 cvardia ship $*/
3:
4: g_address_details PO_HR_LOCATION.address; -- Its a PL/SQL table of po_address_details_gt rowtype
5:
6: g_addr_prompt_query PO_HR_LOCATION.addr_prompt_query; --PL/SQL table for storing style code, query and prompt list.
7:
8: -- Debugging booleans used to bypass logging when turned off
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

Line 13: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION';

9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Logging constants
13: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION';
14: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
15: --
16: /********************************************************************************
17: ** Procedure get_address

Line 665: c_log_head CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION.';

661: l_addr_prompt_query_count number := 0;
662: l_location_id_exists varchar2(1) := 'N';
663: l_style_code_exists varchar2(1) := 'N';
664:
665: c_log_head CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION.';
666: l_api_name CONSTANT VARCHAR2(30):= 'GET_ALLADDRESS_LINES';
667:
668:
669: Begin

Line 1184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt Before inserting values in global temp table');

1180: begin
1181:
1182: l_count := g_address_details.count ;
1183: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt Before inserting values in global temp table');
1185: END IF;
1186: FOR i IN 1..l_count LOOP
1187: INSERT INTO po_address_details_gt
1188: (location_id,

Line 1275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: After inserting values in global temp table');

1271: g_address_details(i).addr_data_19,
1272: g_address_details(i).addr_data_20);
1273: end loop;
1274: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: After inserting values in global temp table');
1276: END IF;
1277:
1278: g_address_details.delete;
1279:

Line 1283: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: Error while inserting values in global temp table');

1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1283: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: Error while inserting values in global temp table');
1284: END IF;
1285: end;
1286:
1287: -----------------------------------------------------------

Line 1319: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');

1315: l_state_or_province Varchar2(240) := '';
1316:
1317: BEGIN
1318: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1319: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1320: END IF;
1321: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1322: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1323: END IF;

Line 1322: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);

1318: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1319: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1320: END IF;
1321: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1322: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1323: END IF;
1324:
1325: get_address
1326: (p_location_id => p_location_id,

Line 1356: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION',

1352: l_address_lines := l_address_line_1 || ', ' || l_address_line_2 ||
1353: l_address_line_3 || l_address_line_4;
1354: l_formatted_address := substrb(l_address_lines || l_address_info || ', '|| l_territory, 1,2000);
1355: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1356: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION',
1357: 'Complete address: '|| l_formatted_address);
1358: END IF;
1359:
1360: Return l_formatted_address;

Line 1365: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,'PO_HR_LOCATION','Error in Retrieving address');

1361:
1362: Exception
1363: When Others then
1364: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1365: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,'PO_HR_LOCATION','Error in Retrieving address');
1366: END IF;
1367: l_formatted_address := null;
1368: END;
1369:

Line 1370: END PO_HR_LOCATION;

1366: END IF;
1367: l_formatted_address := null;
1368: END;
1369:
1370: END PO_HR_LOCATION;