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.6.12020000.2 2013/02/10 14:40:11 vegajula 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.6.12020000.2 2013/02/10 14:40:11 vegajula 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.6.12020000.2 2013/02/10 14:40:11 vegajula 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 687: c_log_head CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION.';

683: l_addr_prompt_query_count number := 0;
684: l_location_id_exists varchar2(1) := 'N';
685: l_style_code_exists varchar2(1) := 'N';
686:
687: c_log_head CONSTANT VARCHAR2(30) := 'PO_HR_LOCATION.';
688: l_api_name CONSTANT VARCHAR2(30):= 'GET_ALLADDRESS_LINES';
689:
690:
691: Begin

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

1213: begin
1214:
1215: l_count := g_address_details.count ;
1216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt Before inserting values in global temp table');
1218: END IF;
1219: FOR i IN 1..l_count LOOP
1220: INSERT INTO po_address_details_gt
1221: (location_id,

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

1304: g_address_details(i).addr_data_19,
1305: g_address_details(i).addr_data_20);
1306: end loop;
1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: After inserting values in global temp table');
1309: END IF;
1310:
1311: g_address_details.delete;
1312:

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

1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1316: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: Error while inserting values in global temp table');
1317: END IF;
1318: end;
1319:
1320: -----------------------------------------------------------

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

1348: l_state_or_province Varchar2(240) := '';
1349:
1350: BEGIN
1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1353: END IF;
1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1356: END IF;

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

1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1353: END IF;
1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1356: END IF;
1357:
1358: get_address
1359: (p_location_id => p_location_id,

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

1385: l_address_lines := l_address_line_1 || ', ' || l_address_line_2 ||
1386: l_address_line_3 || l_address_line_4;
1387: l_formatted_address := substrb(l_address_lines || l_address_info || ', '|| l_territory, 1,2000);
1388: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1389: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION',
1390: 'Complete address: '|| l_formatted_address);
1391: END IF;
1392:
1393: Return l_formatted_address;

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

1394:
1395: Exception
1396: When Others then
1397: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1398: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,'PO_HR_LOCATION','Error in Retrieving address');
1399: END IF;
1400: l_formatted_address := null;
1401: END;
1402:

Line 1403: END PO_HR_LOCATION;

1399: END IF;
1400: l_formatted_address := null;
1401: END;
1402:
1403: END PO_HR_LOCATION;