APPS.CTO_MATCH_CONFIG dependencies on CTO_UTILITY_PK

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

1971: -- to wait so that user does not have to resubmit the process again.
1972: --
1973: IF( lPerformMatch in ( 'Y' , 'C' )) then
1974:
1975: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||
1976: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
1977: IF PG_DEBUG <> 0 THEN
1978: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1979: END IF; --Bugfix 6452747

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

1974:
1975: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: start time: ' ||
1976: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
1977: IF PG_DEBUG <> 0 THEN
1978: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1979: END IF; --Bugfix 6452747
1980:
1981: CTO_UTILITY_PK.lock_for_match(
1982: x_return_status => x_return_status,

Line 1981: CTO_UTILITY_PK.lock_for_match(

1977: IF PG_DEBUG <> 0 THEN
1978: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: start time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1979: END IF; --Bugfix 6452747
1980:
1981: CTO_UTILITY_PK.lock_for_match(
1982: x_return_status => x_return_status,
1983: xMsgCount => x_msg_count,
1984: xMsgData => x_msg_data,
1985: x_lock_status => l_lock_status,

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

1985: x_lock_status => l_lock_status,
1986: x_hash_value => l_hash_value,
1987: p_line_id => lNextRec.line_id );
1988:
1989: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1990: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1993: END IF; --Bugfix 6452747

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

1988:
1989: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling cto_utility_pk.lock_for_match: end time: ' ||
1990: to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));*/
1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1993: END IF; --Bugfix 6452747
1994:
1995: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1996: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');

Line 2117: CTO_UTILITY_PK.release_lock(

2113: ' with config item ' ||
2114: to_char(lXConfigId), 1);
2115: END IF;
2116:
2117: CTO_UTILITY_PK.release_lock(
2118: x_return_status => x_return_status,
2119: x_Msg_Count => x_Msg_Count,
2120: x_Msg_Data => x_msg_data,
2121: p_hash_value => l_hash_value);