APPS.CTO_MATCH_CONFIG dependencies on CTO_UTILITY_PK

Line 2005: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||

2001: -- to wait so that user does not have to resubmit the process again.
2002: --
2003: IF( lPerformMatch in ( 'Y' , 'C' )) then
2004:
2005: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||
2006: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
2007: IF PG_DEBUG <> 0 THEN
2008: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2009: END IF; --Bugfix 6452747

Line 2008: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);

2004:
2005: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||
2006: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
2007: IF PG_DEBUG <> 0 THEN
2008: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2009: END IF; --Bugfix 6452747
2010:
2011: CTO_UTILITY_PK.lock_for_match(
2012: x_return_status => x_return_status,

Line 2011: CTO_UTILITY_PK.lock_for_match(

2007: IF PG_DEBUG <> 0 THEN
2008: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2009: END IF; --Bugfix 6452747
2010:
2011: CTO_UTILITY_PK.lock_for_match(
2012: x_return_status => x_return_status,
2013: xMsgCount => x_msg_count,
2014: xMsgData => x_msg_data,
2015: x_lock_status => l_lock_status,

Line 2024: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||

2020: -- bug 16352937
2021: --
2022: x_hash_value := l_hash_value;
2023:
2024: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
2025: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
2026: IF PG_DEBUG <> 0 THEN
2027: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2028: END IF; --Bugfix 6452747

Line 2027: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);

2023:
2024: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
2025: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
2026: IF PG_DEBUG <> 0 THEN
2027: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2028: END IF; --Bugfix 6452747
2029:
2030: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2031: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

Line 2152: CTO_UTILITY_PK.release_lock(

2148: ' with config item ' ||
2149: to_char(lXConfigId), 1);
2150: END IF;
2151:
2152: CTO_UTILITY_PK.release_lock(
2153: x_return_status => x_return_status,
2154: x_Msg_Count => x_Msg_Count,
2155: x_Msg_Data => x_msg_data,
2156: p_hash_value => l_hash_value);