DBA Data[Home] [Help]

APPS.OZF_SUPP_TRD_PRFLS_PKG dependencies on FND_API

Line 171: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) 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
172: px_org_id := MO_GLOBAL.get_current_org_id();
173: END IF;
174:
175: px_object_version_number := 1;

Line 561: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),

557:
558: Update ozf_supp_trd_prfls_all
559: SET
560: supp_trade_profile_id = p_supp_trade_profile_id,
561: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),
562: last_update_date = p_last_update_date,
563: last_updated_by = p_last_updated_by,
564: last_update_login = p_last_update_login,
565: request_id = p_request_id,

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: ssd_imd_claim_flag = p_ssd_imd_claim_flag
670:
671: WHERE supp_trade_profile_id = p_supp_trade_profile_id;
672: IF (SQL%NOTFOUND) THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: END Update_Row;
676:
677:

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: BEGIN
698: DELETE FROM ozf_supp_trd_prfls_all
699: WHERE supp_trade_profile_id = p_supp_trade_profile_id;
700: If (SQL%NOTFOUND) then
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: End If;
703: END Delete_Row ;
704:
705: