eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_UTILITY_PVT dependencies on ASO_UTILITY_PVT

Line 1: PACKAGE BODY ASO_UTILITY_PVT as

1: PACKAGE BODY ASO_UTILITY_PVT as
2: /* $Header: asovutlb.pls 120.29 2012/01/03 05:42:36 rassharm ship $ */
3: --
4: -- NAME
5: -- ASO_UTILITY_PVT

Line 5: -- ASO_UTILITY_PVT

1: PACKAGE BODY ASO_UTILITY_PVT as
2: /* $Header: asovutlb.pls 120.29 2012/01/03 05:42:36 rassharm ship $ */
3: --
4: -- NAME
5: -- ASO_UTILITY_PVT
6: --
7: -- HISTORY
8: -- 10/18/2002 hyang - 2633507, performance fix
9: --

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):='ASO_UTILITY_PVT';

7: -- HISTORY
8: -- 10/18/2002 hyang - 2633507, performance fix
9: --
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):='ASO_UTILITY_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12):='asovutlb.pls';
13:
14: PROCEDURE Start_API(
15: p_api_name IN VARCHAR2,

Line 388: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type,

384: NULL;
385: END Set_Message;
386:
387: PROCEDURE Gen_Flexfield_Where(
388: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type,
389: x_flex_where_clause OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
390: l_flex_where_cl VARCHAR2(2000) := NULL;
391: BEGIN
392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 394: --dbms_output.put_line('ASO_UTILITY_PVT Generate Flexfield Where: begin');

390: l_flex_where_cl VARCHAR2(2000) := NULL;
391: BEGIN
392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
393: null;
394: --dbms_output.put_line('ASO_UTILITY_PVT Generate Flexfield Where: begin');
395: END IF;
396:
397: FOR i IN 1..p_flex_where_tbl_type.count LOOP
398: IF (p_flex_where_tbl_type(i).value IS NOT NULL

Line 408: --dbms_output.put_line('ASO_UTILITY_PVT Generate Flexfield Where: end');

404: x_flex_where_clause := l_flex_where_cl;
405:
406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
407: null;
408: --dbms_output.put_line('ASO_UTILITY_PVT Generate Flexfield Where: end');
409: END IF;
410: END;
411:
412: PROCEDURE Bind_Flexfield_Where(

Line 414: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type) IS

410: END;
411:
412: PROCEDURE Bind_Flexfield_Where(
413: p_cursor_id IN NUMBER,
414: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type) IS
415: BEGIN
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
417: null;
418: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: begin');

Line 418: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: begin');

414: p_flex_where_tbl_type IN ASO_UTILITY_PVT.flex_where_tbl_type) IS
415: BEGIN
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
417: null;
418: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: begin');
419: END IF;
420:
421: FOR i IN 1..p_flex_where_tbl_type.count LOOP
422: IF (p_flex_where_tbl_type(i).value IS NOT NULL

Line 431: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: end');

427: END LOOP;
428:
429: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
430: null;
431: --dbms_output.put_line('ASO_UTILITY_PVT Bind Flexfield Where: end');
432: END IF;
433: END;
434:
435:

Line 6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');

6332: IS
6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6334: BEGIN
6335: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');
6338: END IF;
6339:
6340: IF (p_attribute = G_DEFAULT_ORDER_TYPE) THEN

Line 6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');

6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6334: BEGIN
6335: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');
6338: END IF;
6339:
6340: IF (p_attribute = G_DEFAULT_ORDER_TYPE) THEN
6341: BEGIN

Line 6398: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');

6394: END;
6395: END IF;
6396:
6397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6398: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');
6399: END IF;
6400:
6401: RETURN l_attribute_value;
6402:

Line 6414: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');

6410:
6411: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
6412:
6413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6414: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6415: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_organization_id '||l_organization_id,1,'Y');
6416: END IF;
6417:
6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);

Line 6415: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_organization_id '||l_organization_id,1,'Y');

6411: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
6412:
6413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6414: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6415: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_organization_id '||l_organization_id,1,'Y');
6416: END IF;
6417:
6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);
6419:

Line 6422: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');

6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);
6419:
6420:
6421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6422: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');
6423: END IF;
6424:
6425: RETURN l_attribute_value;
6426:

Line 6499: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : No record found for the quote number, inserting the new record.', 1, 'Y');

6495: FETCH cur_find_rec INTO l_quote_number, l_conc_request_id ;
6496:
6497: IF (cur_find_rec%ROWCOUNT = 0) THEN
6498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6499: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : No record found for the quote number, inserting the new record.', 1, 'Y');
6500: END IF;
6501: l_to_insert := 1;
6502: END IF ;
6503:

Line 6510: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number passed but the conc request id is not null, hence inserting the new record.', 1, 'Y');

6506: IF (l_conc_request_id IS NOT null)
6507: THEN
6508: -- Record exists but a conc request id is also present, hence insert the record
6509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6510: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number passed but the conc request id is not null, hence inserting the new record.', 1, 'Y');
6511: END IF;
6512: l_to_insert := 1;
6513: END IF;
6514:

Line 6519: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number and the conc request id is null, hence no need to insert the new record.', 1, 'Y');

6515: IF (l_conc_request_id IS null)
6516: THEN
6517: -- Record exists with a null conc request id, hence we need not insert a new record
6518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6519: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number and the conc request id is null, hence no need to insert the new record.', 1, 'Y');
6520: END IF;
6521: l_found_rec := 1;
6522: END IF;
6523:

Line 6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');

6535:
6536: IF (l_to_insert = 1) THEN
6537:
6538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6543: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(

Line 6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');

6536: IF (l_to_insert = 1) THEN
6537:
6538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6543: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
6544: P_QUOTE_NUMBER => p_quote_number,

Line 6561: l_error_text := 'Error in ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : ' || SQLERRM;

6557: END IF;
6558:
6559: EXCEPTION
6560: WHEN OTHERS THEN
6561: l_error_text := 'Error in ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : ' || SQLERRM;
6562: aso_upgrade_pvt.add_message( p_module_name => l_module_name,
6563: p_error_level => 'ERROR',
6564: p_error_text => l_error_text,
6565: p_source_name => l_source_name

Line 6712: END ASO_UTILITY_PVT;

6708:
6709: END Tax_Rec_Exists;
6710:
6711:
6712: END ASO_UTILITY_PVT;
6713: