DBA Data[Home] [Help]

APPS.OZF_SUPP_TRD_PRFLS_PKG dependencies on OZF_UTILITY_PVT

Line 152: OZF_UTILITY_PVT.debug_message( 'Into begin 1');

148:
149:
150: BEGIN
151: IF g_debug THEN
152: OZF_UTILITY_PVT.debug_message( 'Into begin 1');
153: END IF;
154:
155: -- R12 Enhancements
156: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

Line 162: OZF_UTILITY_PVT.debug_message( 'before insert 2');

158: END IF;
159:
160: px_object_version_number := 1;
161: IF g_debug THEN
162: OZF_UTILITY_PVT.debug_message( 'before insert 2');
163: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
164: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
165: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
166: END IF;

Line 163: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );

159:
160: px_object_version_number := 1;
161: IF g_debug THEN
162: OZF_UTILITY_PVT.debug_message( 'before insert 2');
163: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
164: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
165: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
166: END IF;
167:

Line 164: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );

160: px_object_version_number := 1;
161: IF g_debug THEN
162: OZF_UTILITY_PVT.debug_message( 'before insert 2');
163: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
164: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
165: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
166: END IF;
167:
168: INSERT INTO ozf_supp_trd_prfls_all(

Line 165: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );

161: IF g_debug THEN
162: OZF_UTILITY_PVT.debug_message( 'before insert 2');
163: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
164: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
165: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
166: END IF;
167:
168: INSERT INTO ozf_supp_trd_prfls_all(
169: supp_trade_profile_id,

Line 380: OZF_UTILITY_PVT.debug_message( 'after insert 2');

376:
377:
378: );
379: IF g_debug THEN
380: OZF_UTILITY_PVT.debug_message( 'after insert 2');
381: END IF;
382:
383: END Insert_Row;
384:

Line 507: OZF_UTILITY_PVT.debug_message( 'Inside update table ');

503: IS
504: BEGIN
505:
506: IF g_debug THEN
507: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
508: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
509: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
510: END IF;
511:

Line 508: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);

504: BEGIN
505:
506: IF g_debug THEN
507: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
508: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
509: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
510: END IF;
511:
512: Update ozf_supp_trd_prfls_all

Line 509: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);

505:
506: IF g_debug THEN
507: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
508: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
509: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
510: END IF;
511:
512: Update ozf_supp_trd_prfls_all
513: SET