DBA Data[Home] [Help]

APPS.OZF_SUPP_TRD_PRFLS_PKG dependencies on OZF_UTILITY_PVT

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

163:
164:
165: BEGIN
166: IF g_debug THEN
167: OZF_UTILITY_PVT.debug_message( 'Into begin 1');
168: END IF;
169:
170: -- R12 Enhancements
171: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

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

173: END IF;
174:
175: px_object_version_number := 1;
176: IF g_debug THEN
177: OZF_UTILITY_PVT.debug_message( 'before insert 2');
178: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
179: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
180: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
181: END IF;

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

174:
175: px_object_version_number := 1;
176: IF g_debug THEN
177: OZF_UTILITY_PVT.debug_message( 'before insert 2');
178: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
179: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
180: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
181: END IF;
182:

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

175: px_object_version_number := 1;
176: IF g_debug THEN
177: OZF_UTILITY_PVT.debug_message( 'before insert 2');
178: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
179: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
180: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
181: END IF;
182:
183: INSERT INTO ozf_supp_trd_prfls_all(

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

176: IF g_debug THEN
177: OZF_UTILITY_PVT.debug_message( 'before insert 2');
178: OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
179: OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
180: OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
181: END IF;
182:
183: INSERT INTO ozf_supp_trd_prfls_all(
184: supp_trade_profile_id,

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

411:
412:
413: );
414: IF g_debug THEN
415: OZF_UTILITY_PVT.debug_message( 'after insert 2');
416: END IF;
417:
418: END Insert_Row;
419:

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

549: IS
550: BEGIN
551:
552: IF g_debug THEN
553: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
554: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
555: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
556: END IF;
557:

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

550: BEGIN
551:
552: IF g_debug THEN
553: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
554: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
555: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
556: END IF;
557:
558: Update ozf_supp_trd_prfls_all

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

551:
552: IF g_debug THEN
553: OZF_UTILITY_PVT.debug_message( 'Inside update table ');
554: OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
555: OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
556: END IF;
557:
558: Update ozf_supp_trd_prfls_all
559: SET